sys.dm_hadr_availability_replica_cluster_states (Transact-SQL)

Applies to: yesSQL Server (all supported versions)

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 name Data type Description
replica_id uniqueidentifier Unique identifier of the availability replica.
replica_server_name nvarchar(256) Name of the instance of SQL Server hosting the replica.
group_id uniqueidentifier Unique identifier of the availability group.
join_state tinyint 0 = Not joined

1 = Joined, standalone

2 = Joined, failover cluster instance
join_state_desc nvarchar(60) NOT_JOINED

JOINED_STANDALONE

JOINED_FAILOVER_CLUSTER_INSTANCE

Security

Permissions

Requires VIEW SERVER STATE permission on the server.

See Also

Monitor Availability Groups (Transact-SQL)