Export (0) Print
Expand All

sys.dm_hadr_availability_replica_cluster_states (Transact-SQL)

Returns a row for each AlwaysOn availability replica (regardless of its join state) of all AlwaysOn 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 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 instance

2 = Joined, failover cluster instance

join_state_desc

nvarchar(60)

NOT_JOINED

JOINED_STANDALONE_INSTANCE

JOINED_FAILOVER_CLUSTER_INSTANCE

Permissions

Requires VIEW SERVER STATE permission on the server.

Community Additions

ADD
Show:
© 2014 Microsoft