[AlwaysOn2017] DMV-Sys.dm_hadr_availability_replica_cluster_states of AlwaysOn
12、 Sys. dm_hadr_availability_replica_cluster_states
Returns a row for each AlwaysOn availability replica (regardless of membership status) for all AlwaysOn availability groups in the Windows Server Failover Cluster (WSFC) cluster (regardless of replica location).
listing
data type
described
replica_id
uniqueidentifier
Unique identifier of the availability copy.
replica_server_name
nvarchar(256)
The name of the SQL Server instance hosting the replica.
group_id
uniqueidentifier
Unique identifier for the availability group.
join_state
join_state_desc
tinyint
nvarchar(60)
0 = NOT_JOINED
1 = JOINED_STANDALONE_INSTANCE Joined, standalone instance
2 = JOINED_FAILOVER_CLUSTER_INSTANCE joined, failover cluster instance
