.png)
sys.dm_hadr_name_id_map (Transact-SQL)
Shows the mapping of AlwaysOn 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. |
