Skip to main content

This browser is no longer supported.

Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.

Download Microsoft Edge More info about Internet Explorer and Microsoft Edge
Read in English
Read in English Edit
Twitter LinkedIn Facebook Email

Always On Availability Groups Dynamic Management Views - Functions

  • Article
  • 11/18/2022
  • 2 minutes to read

In this article

Applies to: SQL Server

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

In this section

  • sys.dm_hadr_ag_threads
  • sys.dm_hadr_auto_page_repair
  • sys.dm_hadr_automatic_seeding
  • sys.dm_hadr_availability_group_states
  • sys.dm_hadr_availability_replica_cluster_nodes
  • sys.dm_hadr_availability_replica_cluster_states
  • sys.dm_hadr_availability_replica_states
  • sys.dm_hadr_cluster
  • sys.dm_hadr_cluster_members
  • sys.dm_hadr_cluster_networks
  • sys.dm_hadr_database_replica_cluster_states
  • sys.dm_hadr_database_replica_states
  • sys.dm_hadr_db_threads
  • sys.dm_hadr_instance_node_map
  • sys.dm_hadr_name_id_map
  • sys.dm_hadr_physical_seeding_stats
  • sys.dm_tcp_listener_states

See also

  • Always On Availability Groups (SQL Server)
  • Always On Availability Groups Catalog Views (Transact-SQL)
  • Monitor Availability Groups (Transact-SQL)

Additional resources

  • Previous Versions
  • Blog
  • Contribute
  • Privacy
  • Terms of Use
  • Trademarks
  • © Microsoft 2023

Additional resources

In this article

  • Previous Versions
  • Blog
  • Contribute
  • Privacy
  • Terms of Use
  • Trademarks
  • © Microsoft 2023