Skip to content

Latest commit

 

History

History
46 lines (38 loc) · 1.92 KB

File metadata and controls

46 lines (38 loc) · 1.92 KB
title sys.dm_hadr_availability_replica_cluster_nodes (Transact-SQL) | Microsoft Docs
ms.custom
ms.date 06/10/2016
ms.prod sql
ms.reviewer
ms.technology system-objects
ms.topic language-reference
f1_keywords
dm_hadr_availability_replica_cluster_nodes
sys.dm_hadr_availability_replica_cluster_nodes_TSQL
dm_hadr_availability_replica_cluster_nodes_TSQL
sys.dm_hadr_availability_replica_cluster_nodes
dev_langs
TSQL
helpviewer_keywords
Availability Groups [SQL Server], monitoring
Availability Groups [SQL Server], WSFC clusters
sys.dm_hadr_availability_replica_cluster_nodes dynamic management view
ms.assetid dbd7e416-badd-4332-a45c-438aa0145a99
author MikeRayMSFT
ms.author mikeray

sys.dm_hadr_availability_replica_cluster_nodes (Transact-SQL)

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

Returns a row for every availability replica (regardless of join state) of the Always On availability groups in the Windows Server Failover Clustering (WSFC) cluster.

Column name Data type Description
group_name nvarchar(256) Name of the availability group.
replica_server_name nvarchar(256) Name of the instance of [!INCLUDEssNoVersion] hosting the replica.
node_name nvarchar(256) Name of the cluster node.

Security

Permissions

Requires VIEW SERVER STATE permission on the server.

See Also

Monitor Availability Groups (Transact-SQL)
Overview of Always On Availability Groups (SQL Server)