MS SQL Server Always On Availability Groups Monitoring
SQL Sentry makes it easier to monitor Always On Availability Groups
SQL Sentry® provides a rich set of performance analysis capabilities to efficiently manage and monitor any Microsoft (MS) SQL Server availability group (AG) environment. The AlwaysOn Management tab in SQL Sentry displays information about your AG environment, including overview diagrams with complete topology, detail-level grid view, and historical charting.
Overview Area
The Overview area in the AlwaysOn Management tab contains several layouts for managing your AG environment from several perspectives, including the Windows Server Failover Cluster (WSFC) level, the availability group level, the SQL Server instance level, and the Replica level. The layout style can be changed from a drop-down menu in the Overview area.
When you monitor the SQL Server instance hosting the primary replica of an availability group with SQL Sentry, the entire topology of the availability group is displayed as part of the Overview area. Unwatched instances hosting replicas appear in a gray background color.
You can zoom in or out of the Overview area to view information, such as whether the replicants are in synchronous or asynchronous commit mode, replica health, log send or recovery queue growth, quorum votes, and the amount of data being transferred. Bottlenecks are highlighted in the environment by dynamically changing color and with changing flow lines for optimal insight into the health of your AG environment.
Grid View Area
The Grid View section is composed of several tabs, which allow you to see both high-level and detail-level metrics concerning your AG environment. This section gives you a rich and easily navigable version of the entire AG schema.
For example, one of the Grid View tabs allows you to view not only the SQL Server instance a database belongs to but its sync state, the database state (whether it’s in recovery pending, suspect, or online state), and much more.
Historical View Area
This section of the SQL Sentry AlwaysOn area contains tabs for charting, error logs, and replica state changes. Information in each tab is shown based on the selected time range.
Each of the History tabs is context-aware and displays information based on the node or row selected in either the Overview or Grid View area.
The Charting tab displays data traffic between the replicas as well as the log send and recovery queue metrics in kilobytes.
The Error Log tab allows you to view AG health events classified as errors related to the selected node from the Overview or row from the Grid View area.
The Replica State Changes tab enables you to view any AG health events classified as replica state changes related to the selected node.
AG Health Alerts
You can use the built-in fail-safe conditions to notify you when replicas become unhealthy and availability groups fail over.
Alternatively, you can write your own alerts and responses using the powerful Advisory Conditions framework in SQL Sentry. For example, you can calculate whether the databases in an availability group meet your Recovery Time Objective (RTO).
What is SQL Sentry AlwaysOn monitoring?
Learn MoreSQL Sentry® AlwaysOn monitoring helps you visually monitor and manage important information about your Microsoft SQL Server Always On availability groups (AGs). Introduced in SQL Server 2012, the Always On AG feature is a high-availability and disaster recovery (HA/DR) solution providing an enterprise-level alternative to database mirroring.
AGs support failover environments for discrete sets of user databases that fail over together. Each AG consists of a set of read-write primary databases and one to eight sets of corresponding secondary databases. Optionally, secondary databases can be made available for read-only access and/or some backup operations.
What can you do with SQL Sentry AlwaysOn monitoring?
Learn More- Dramatically increase the visibility and manageability of Always On availability groups
- Easily organize and manage your Always On assets in the best way for you
- See how AGs and failover cluster instances (FCIs) are distributed across your Windows Server Failover Cluster nodes
- Track key metrics, such as data being sent to and from replicas
- See where bottlenecks may exist in the environment over any date range at a glance
- Configure alerts and other actions for important failover and replica health events
- What is SQL Sentry AlwaysOn monitoring?
- What can you do with SQL Sentry AlwaysOn monitoring?
What is SQL Sentry AlwaysOn monitoring?
SQL Sentry® AlwaysOn monitoring helps you visually monitor and manage important information about your Microsoft SQL Server Always On availability groups (AGs). Introduced in SQL Server 2012, the Always On AG feature is a high-availability and disaster recovery (HA/DR) solution providing an enterprise-level alternative to database mirroring.
AGs support failover environments for discrete sets of user databases that fail over together. Each AG consists of a set of read-write primary databases and one to eight sets of corresponding secondary databases. Optionally, secondary databases can be made available for read-only access and/or some backup operations.
“The [SQL Sentry] visualization of Always On availability groups is quite helpful, and being able to see the volume of data helps determine hot servers.”
SQL Sentry Customer
Get started with SQL Server Always On availability group monitoring
SolarWinds SQL Sentry
Fast root cause analysis
Visibility across the data estate
Deep, actionable performance metrics with easy deep-dive capabilities
