TechNet
Export (0) Print
Expand All

sys.dm_hadr_name_id_map (Transact-SQL)

 

Updated: June 10, 2016

THIS TOPIC APPLIES TO: yesSQL Server (starting with 2012)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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 nameData typeDescription
ag_namenvarchar(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_iduniqueidentifierUnique identifier (GUID) of the availability group.
ag_resource_idnvarchar(256)Unique ID of the availability group as a resource in the WSFC cluster.
ag_group_idnvarchar(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)

Community Additions

ADD
Show:
© 2016 Microsoft