Export (0) Print
Expand All

sys.dm_hadr_availability_replica_cluster_nodes (Transact-SQL)

Returns a row for every availability replica (regardless of join state) of the AlwaysOn availability groups in the Windows Server Failover Clustering (WSFC) cluster.

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

Column name

Data type

Description

group_name

nvarchar(256)

Name of the availability group.

replica_server_name

nvarchar(256)

Name of the instance of SQL Server hosting the replica.

node_name

nvarchar(256)

Name of the cluster node.

Permissions

Requires VIEW SERVER STATE permission on the server.

Community Additions

ADD
Show:
© 2014 Microsoft