Skip to content

Latest commit

 

History

History
49 lines (38 loc) · 2.11 KB

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

File metadata and controls

49 lines (38 loc) · 2.11 KB
title description author ms.author ms.date ms.service ms.subservice ms.topic f1_keywords helpviewer_keywords dev_langs
sys.dm_hadr_availability_replica_cluster_nodes (Transact-SQL)
Returns a row for every availability replica of the availability groups in the WSFC cluster.
rwestMSFT
randolphwest
10/17/2023
sql
system-objects
reference
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
Availability Groups [SQL Server], monitoring
Availability Groups [SQL Server], WSFC clusters
sys.dm_hadr_availability_replica_cluster_nodes dynamic management view
TSQL

sys.dm_hadr_availability_replica_cluster_nodes (Transact-SQL)

[!INCLUDE SQL Server]

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 [!INCLUDE ssNoVersion] hosting the replica.
node_name nvarchar(256) Name of the cluster node.

Remarks

[!INCLUDE dmv-cluster-column-display]

Permissions

For [!INCLUDE sssql19-md] and previous versions, requires VIEW SERVER STATE permission on the server.

For [!INCLUDE sssql22-md] and later versions, requires VIEW SERVER PERFORMANCE STATE permission on the server.

Related content