sys-dm-hadr-availability-replica-cluster-states-transact-sql.md

title	sys.dm_hadr_availability_replica_cluster_states (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	06/10/2016
ms.prod	sql-non-specified
ms.prod_service	database-engine
ms.service
ms.component	dmv's
ms.reviewer
ms.suite	sql
ms.technology	database-engine
ms.tgt_pltfrm
ms.topic	language-reference
f1_keywords	sys.dm_hadr_availability_replica_cluster_states_TSQL dm_hadr_availability_replica_cluster_states sys.dm_hadr_availability_replica_cluster_states dm_hadr_availability_replica_cluster_states_TSQL
dev_langs	TSQL
helpviewer_keywords	Availability Groups [SQL Server], monitoring Availability Groups [SQL Server], WSFC clusters sys.dm_hadr_availability_replica_cluster_states dynamic management view
ms.assetid	2e0dd780-6a71-4f4b-b7f7-6e063bec71d6
caps.latest.revision	12
author	MikeRayMSFT
ms.author	mikeray
manager	jhubbard
ms.workload	Inactive

sys.dm_hadr_availability_replica_cluster_states (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2012-xxxx-xxxx-xxx-md]

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 [!INCLUDEssNoVersion] 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

Security

Permissions

Requires VIEW SERVER STATE permission on the server.

See Also

Monitor Availability Groups (Transact-SQL)