Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

sys.dm_hadr_name_id_map (Transact-SQL)

Applies To: SQL Server 2014, SQL Server 2016 Preview

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

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.

Applies to: SQL Server (SQL Server 2012 through current version).

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.

Community Additions

ADD
Show:
© 2015 Microsoft