Monitoring for MSSQL Server Always On Availability Groups

Check this against your version

This article was last updated on Sep 13, 2024, before Applicare 10.0 was released (Jun 19, 2026), and has not been re-checked for Applicare 10.0. Confirm the steps in your environment or contact Support.

Applicare SingleAgent is an effective tool for managing and monitoring your availability groups. It offers a comprehensive view of performance across your MS SQL Server, helping you identify and troubleshoot issues at the Windows Server Failover Cluster (WSFC) level, SQL Server instance level, and Replica level.

Sensor Analyzer

Sensor Analyzer allows users to create and customize their own dashboards, enabling them to monitor the metrics that matter most to them..

  • Visualize data trends: Charts enable you to swiftly recognize trends in your data, aiding in the detection of potential issues or opportunities.
  • Identify Anomalies: Charts can highlight anomalies such as sudden spikes or drops, which is useful for troubleshooting.
  • Correlate Data: Charts facilitate the correlation of data from various sources. Helping you understand the root cause of issues.

Server Availability Replication

This feature monitors the availability replicas in Always On availability groups in SQL Server. It includes sensors for both the primary and the secondary replicas, with send/receive counters reflecting the status of each local replica.

Screenshot 1 — Monitoring for MSSQL Server Always On Availability Groups

Database Availability Replication

This feature provides details about the secondary databases of an Always On availability group in SQL Server.

Screenshot 2 — Monitoring for MSSQL Server Always On Availability Groups

SQL Server Instance

Monitor transactions and the transaction log to assess user activity within the database and the growth of the transaction log. The level of user activity impacts database performance and influence log size, locking, and replication.

Screenshot 3 — Monitoring for MSSQL Server Always On Availability Groups

Reports

Reports offer on-demand access to historical analysis data, enabling you to understand and optimize the performance of your MS SQL Server Always On availability groups.

Screenshot 4 — Monitoring for MSSQL Server Always On Availability Groups

Reports Scheduling

Auto report generation and delivery through scheduling can save time and effort, leading to enhanced performance and efficiency.

Screenshot 5 — Monitoring for MSSQL Server Always On Availability Groups

Alerts

Alerts notify you of potential issues or opportunities, allowing you to take prompt corrective action reduce impact.

Screenshot 6 — Monitoring for MSSQL Server Always On Availability Groups

Monitoring with Applicare

Was this article helpful?

Votes and follows are kept by Zendesk, so they need a Help Center account. These buttons open this article there.

Opens Zendesk · needs internet and sign-in

Still stuck? Contact support