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.
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.