TechNet
Export (0) Print
Expand All

sys.dm_hadr_availability_replica_cluster_states (Transact-SQL)

 

Applies To: SQL Server

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.

Applies to: SQL Server (SQL Server 2012 through current version).


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
join_state_descnvarchar(60)NOT_JOINED

JOINED_STANDALONE_INSTANCE

JOINED_FAILOVER_CLUSTER_INSTANCE

Permissions

Requires VIEW SERVER STATE permission on the server.

Monitor Availability Groups (Transact-SQL)

Community Additions

ADD
Show:
© 2016 Microsoft