Shows the mapping of Always On availability groups that the current instance of SQL Server has joined to three unique IDs: an availability group ID, a WSFC resource ID, and a WSFC Group ID. The purpose of this mapping is to handle the scenario in which the WSFC resource/group is renamed.
|Column name||Data type||Description|
|ag_name||nvarchar(256)||Name of the availability group. This is a user-specified name that must be unique within the Windows Server Failover Cluster (WSFC) cluster.|
|ag_id||uniqueidentifier||Unique identifier (GUID) of the availability group.|
|ag_resource_id||nvarchar(256)||Unique ID of the availability group as a resource in the WSFC cluster.|
|ag_group_id||nvarchar(256)||Unique WSFC Group ID of the availability group.|
Requires VIEW SERVER STATE permission on the server.
Always On Availability Groups Dynamic Management Views and Functions (Transact-SQL)
Always On Availability Groups Catalog Views (Transact-SQL)
Monitor Availability Groups (Transact-SQL)
Always On Availability Groups (SQL Server)