You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 8 Current »

The Availability Group Topology report allows users to view the current topology of an AlwaysOn availability group's configuration. The report displays all of the availability groups on the server, replicas that participate in the group, and the databases within the group.

You can filter results by availability group only. The report lists detailed information for availability replicas and corresponding databases.

Availability replica table

Provides information on availability Replica, Roles assigned, Failover mode, Availability Modes selected, and the Secondary Connection Mode.

Availability databases table

Provides information on the Database, Failover readiness, and Synchronization State of the availability databases contained within the selected availability replica.

When to run this report

You should run the Availability Group Topology report to keep track of modifications made to your current AlwaysOn availability groups and avoid any potential setbacks to your high-availability and disaster recovery strategies.



SQL Diagnostic Manager for SQL Server performance monitoring, alerting, and diagnostics for SQL Server.
IDERAProductsPurchase | Support | Community | Resources | About Us | Legal
  • No labels