TechNet
Export (0) Print
Expand All

sys.dm_hadr_instance_node_map (Transact-SQL)

 

Applies To: SQL Server

For every instance of SQL Server that hosts an availability replica that is joined to its Always On availability group, returns the name of the Windows Server Failover Clustering (WSFC) node that hosts the server instance. This dynamic management view has the following uses:

Applies to: SQL Server (SQL Server 2012 through current version).
Column nameData typeDescription
ag_resource_idnvarchar(256)Unique ID of the availability group as a resource in the WSFC cluster.
instance_namenvarchar(256)Name—server/instance—of a server instance that hosts a replica for the availability group.
node_namenvarchar(256)Name of the WSFC cluster node.

Requires VIEW SERVER STATE permission on the server.

Entity with relative path '../Topic/AlwaysOn%20Availability%20Groups%20Dynamic%20Management%20Views%20and%20Functions%20(Transact-SQL).md' can not be found, for source topic '{"project_id":"7d6ffa79-2ddc-4606-b774-a6a5d46784cd","entity_id":"ccfaf62c-9f87-43cf-a5e7-8942e91dd041","entity_type":"Article","locale":"en-US"}'.
Entity with relative path '../Topic/AlwaysOn%20Availability%20Groups%20Catalog%20Views%20(Transact-SQL).md' can not be found, for source topic '{"project_id":"7d6ffa79-2ddc-4606-b774-a6a5d46784cd","entity_id":"ccfaf62c-9f87-43cf-a5e7-8942e91dd041","entity_type":"Article","locale":"en-US"}'.
Monitor Availability Groups (Transact-SQL)
Entity with relative path '../Topic/AlwaysOn%20Availability%20Groups%20(SQL%20Server).md' can not be found, for source topic '{"project_id":"7d6ffa79-2ddc-4606-b774-a6a5d46784cd","entity_id":"ccfaf62c-9f87-43cf-a5e7-8942e91dd041","entity_type":"Article","locale":"en-US"}'.

Community Additions

ADD
Show:
© 2016 Microsoft