title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | |||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sys.dm_hadr_name_id_map (Transact-SQL) |
sys.dm_hadr_name_id_map (Transact-SQL) |
rwestMSFT |
randolphwest |
02/27/2023 |
sql |
system-objects |
reference |
|
|
|
[!INCLUDE SQL Server]
Shows the mapping of Always On availability groups that the current instance of [!INCLUDEssNoVersion] 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.
Requires VIEW SERVER PERFORMANCE 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)