Edit

sys.dm_hadr_availability_replica_cluster_nodes (Transact-SQL)

  • Article
  • 2 minutes to read

Applies to: SQL Server

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

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.

Security

Permissions

Requires VIEW SERVER STATE permission on the server.

See Also

Monitor Availability Groups (Transact-SQL)
Overview of Always On Availability Groups (SQL Server)