TechNet
Export (0) Print
Expand All

Always On Availability Groups Dynamic Management Views and Functions (Transact-SQL)

 

THIS TOPIC APPLIES TO: yesSQL Server (starting with 2012)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

This section contains the dynamic management views and functions that are related to Always On Availability Groups.

sys.dm_hadr_auto_page_repairsys.dm_hadr_cluster_networks
sys.dm_hadr_availability_group_statessys.dm_hadr_database_replica_cluster_states
sys.dm_hadr_availability_replica_cluster_nodessys.dm_hadr_database_replica_states
sys.dm_hadr_availability_replica_cluster_statessys.dm_hadr_instance_node_map
sys.dm_hadr_availability_replica_statessys.dm_hadr_name_id_map
sys.dm_hadr_clustersys.dm_tcp_listener_states
sys.dm_hadr_cluster_members

AlwaysOn Availability Groups (SQL Server)
AlwaysOn Availability Groups Catalog Views (Transact-SQL)
Monitor Availability Groups (Transact-SQL)

Community Additions

ADD
Show:
© 2016 Microsoft