TechNet
Export (0) Print
Expand All

sys.dm_hadr_availability_replica_cluster_nodes (Transact-SQL)

 

Updated: June 10, 2016

THIS TOPIC APPLIES TO: yesSQL Server (starting with 2012)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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 nameData typeDescription
group_namenvarchar(256)Name of the availability group.
replica_server_namenvarchar(256)Name of the instance of SQL Server hosting the replica.
node_namenvarchar(256)Name of the cluster node.

Permissions

Requires VIEW SERVER STATE permission on the server.

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

Community Additions

ADD
Show:
© 2016 Microsoft