Shulou(Shulou.com)06/01 Report--

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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.