Skip to main content
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.

Permissions

Requires VIEW SERVER STATE permission on the server.