United States (English)

Home Library Learn Samples Downloads Support Community Forums

MSDN Library

Servers and Enterprise Development

SQL Server

SQL Server 2012

Product Documentation

Books Online for SQL Server 2012

Database Engine

Transact-SQL Reference (Database Engine)

System Views (Transact-SQL)

Dynamic Management Views and Functions (Transact-SQL)

AlwaysOn Availability Groups Dynamic Management Views and Functions

sys.dm_hadr_auto_page_repair (Transact-SQL)

sys.dm_hadr_availability_group_states (Transact-SQL)

sys.dm_hadr_availability_replica_cluster_nodes (Transact-SQL)

sys.dm_hadr_availability_replica_cluster_states (Transact-SQL)

sys.dm_hadr_availability_replica_states (Transact-SQL)

sys.dm_hadr_cluster (Transact-SQL)

sys.dm_hadr_cluster_members (Transact-SQL)

sys.dm_hadr_cluster_networks (Transact-SQL)

sys.dm_hadr_database_replica_cluster_states (Transact-SQL)

sys.dm_hadr_database_replica_states (Transact-SQL)

sys.dm_hadr_instance_node_map (Transact-SQL)

sys.dm_hadr_name_id_map (Transact-SQL)

sys.dm_tcp_listener_states (Transact-SQL)

Minimize

This topic has not yet been rated - Rate this topic

sys.dm_hadr_availability_replica_cluster_nodes (Transact-SQL)

SQL Server 2012

Returns a row for every availability replica (regardless of join state) of the AlwaysOn 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 SQL Server hosting the replica.
node_name	nvarchar(256)	Name of the cluster node.

Permissions

Requires VIEW SERVER STATE permission on the server.

Concepts

Monitor Availability Groups (Transact-SQL)

Overview of AlwaysOn Availability Groups (SQL Server)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

© 2013 Microsoft. All rights reserved.