Always On Cluster Window

The Always On Cluster window displays the availability groups of Microsoft SQL Server. It provides a comprehensive view of all availability groups for which the discovered nodes are primary, showing data at both the node and cluster levels. This window displays key metrics:

  • Name
  • Synchronization Health
  • Estimated Data Loss (sec)
  • Estimated Recovery Time (sec)
  • Redo Queue Size (KB)
  • Redo Rate (KB/sec)
  • Hardened Latency (ms)
  • Automated Backup Preference
Note:

Based on your preferred monitoring approach, you can enable cluster auto-discovery or configure a custom cluster using the Sub-Collectors field under Advanced Options.

Access the Always On Cluster Window

You require:

  • Controller 25.4.0 or higher
  • Database Agent 25.4.0 or higher

To access the Always On Cluster window:

  1. Click the name of the database.
  2. Click the Always On Cluster tab.

Click on an availability group to access detailed tabs:

  • Overview: Displays the detailed view of the availability group
  • Replicas: Displays the available replicas in the availability group
  • Databases: Displays the participating databases in the availability group

Database administrators and operations teams can use this feature to monitor the health and performance of SQL Server availability groups in real time. It helps track synchronization status, detect potential data loss, estimate recovery times, and troubleshoot issues by navigating through the hierarchy:

  • Database Cluster > Availability Group > Replica (<replica_name>) > Database Replica (<database_replica_name>)
  • Database Cluster > Availability Group > Database (<database_name>) > Database Replica (<database_replica_name>)

This ensures high availability and disaster recovery objectives are achieved by providing visibility into the roles and states of cluster nodes and replicas.