Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).
Returns a row for each AlwaysOn availability group in the Windows Server Failover Clustering (WSFC) . Each row contains the availability group metadata from the WSFC cluster.
Applies to: SQL Server (SQL Server 2012 through current version).
Unique identifier (GUID) of the availability group.
Name of the availability group. This is a user-specified name that must be unique within the Windows Server Failover Cluster (WSFC).
Resource ID for the WSFC cluster resource.
Resource Group ID for the WSFC cluster resource group of the availability group.
User-defined failure condition level under which an automatic failover must be triggered, one of the following integer values:
The failure-condition levels (1–5) range from the least restrictive, level 1, to the most restrictive, level 5. A given condition level encompasses all of the less restrictive levels. Thus, the strictest condition level, 5, includes the four less restrictive condition levels (1-4), level 4 includes levels 1-3, and so forth.
To change this value, use the FAILURE_CONDITION_LEVEL option of the ALTER AVAILABILITY GROUP Transact-SQL statement.
Wait time (in milliseconds) for the sp_server_diagnostics system stored procedure to return server-health information, before the server instance is assumed to be slow or hung. The default value is 30000 milliseconds (30 seconds).
To change this value, use the HEALTH_CHECK_TIMEOUT option of ALTER AVAILABILITY GROUPTransact-SQL statement.
Preferred location for performing backups on the availability databases in this availability group. One of:
For more information, see Active Secondaries: Backup on Secondary Replicas (AlwaysOn Availability Groups).
Description of automated_backup_preference, one of: