Support for database clustering with SQL Always ON feature

book

Article ID: 221099

calendar_today

Updated On:

Products

IT Management Suite Ghost Solution Suite

Issue/Introduction

Question:

Can we use a database clustering with SQL Always ON feature turned on for a GSS or ITMS SQL instance for SQL Server 2012/2016/2019 platform?

Environment

ITMS 8.5, 8.6
GSS 3.3 RU7

Resolution

This is not something that we are actively testing. We haven't tested this feature/functionality with our product so we can't say that we "fully support it". You can refer to this information from Microsoft:  https://docs.microsoft.com/en-us/sql/sql-server/failover-clusters/windows/always-on-failover-cluster-instances-sql-server?view=sql-server-2017

Please note this statement:  “This process is transparent to the client or application connecting to SQL Server and this minimizes the downtime the application or clients experience during a failure.”

Having the ITMS or GSS database in a cluster with "SQL Always ON feature" shouldn't matter to us as long as we can access the data from our database without further configuration. If Microsoft SQL Server supports it in order to let access the data in the ITMS or GSS database, then we should be fine.