Skip to main content
sys.dm_hadr_availability_replica_cluster_states (Transact-SQL)

Updated: June 10, 2016

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

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

Column nameData typeDescription
replica_iduniqueidentifierUnique identifier of the availability replica.
replica_server_namenvarchar(256)Name of the instance of SQL Server hosting the replica.
group_iduniqueidentifierUnique identifier of the availability group.
join_statetinyint0 = Not joined

1 = Joined, standalone instance

2 = Joined, failover cluster instance




Requires VIEW SERVER STATE permission on the server.

Monitor Availability Groups (Transact-SQL)