Udostępnij za pośrednictwem


sys.dm_hadr_instance_node_map (Transact-SQL)

For every instance of SQL Server that hosts an availability replica that is joined to its AlwaysOn 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:

  • This dynamic management view is useful for detecting an availability group with multiple availability replicas that are hosted on the same WSFC node, which is an unsupported configuration that could occur after an FCI failover if the availability group is incorrectly configured. For more information, see Failover Clustering and AlwaysOn Availability Groups (SQL Server).

  • When multiple SQL Server instances are hosted on the same WSFC node, the Resource DLL uses this dynamic management view to determine the instance of SQL Server to connect to.

Column name

Data type

Description

ag_resource_id

nvarchar(256)

Unique ID of the availability group as a resource in the WSFC cluster.

instance_name

nvarchar(256)

Name—server/instance—of a server instance that hosts a replica for the availability group.

node_name

nvarchar(256)

Name of the WSFC cluster node.

Permissions

Requires VIEW SERVER STATE permission on the server.

Zobacz także

Koncepcje

Monitor Availability Groups (Transact-SQL)

AlwaysOn Availability Groups (SQL Server)

Inne zasoby

AlwaysOn Availability Groups Dynamic Management Views and Functions (Transact-SQL)

AlwaysOn Availability Groups Catalog Views (Transact-SQL)