Always On Availability Groups Catalog Views (Transact-SQL)

APPLIES TO: SQL Server Azure SQL Database Azure Synapse Analytics Analytics Platform System (PDW)

This section contains catalog views and functions that are related to Always On availability groups.

In this section

• sys.availability_databases_cluster
• sys.availability_group_listener_ip_addresses
• sys.availability_group_listeners
• sys.availability_groups
• sys.availability_groups_cluster
• sys.availability_read_only_routing_lists
• sys.availability_replicas

Note

For information about joined availability databases, see the replica_id and group_database_id columns in sys.databases (Transact-SQL).

See also

• sys.databases (Transact-SQL)
• sys.database_mirroring_endpoints (Transact-SQL)
• Always On Availability Groups (SQL Server)
• Monitor Availability Groups (Transact-SQL)
• Always On Availability Groups Dynamic Management Views and Functions (Transact-SQL)