Monitor SQL Server

AlwaysOn Availability Groups

with SentryOne SQL Sentry

 

What Are SQL Server AlwaysOn Availability Groups?

 

AlwaysOn Availability Groups are a high-availability and disaster-recovery feature introduced with SQL Server 2012, providing enhancements and abilities over database mirroring. An Availability Group protects a set of user databases, supporting up to eight secondary replicas of the primary database. In the event of a failure on the primary, all of the databases within an Availability Group will fail over together and become active on the designated failover partner. Additionally, you can configure secondary replicas to allow read-only activity and most backup operations, potentially taking some of the load away from the primary.

 

 

Visualize your SQL Server AlwaysOn environment in a whole new way with SentryOne SQL Sentry.

With three different ways to analyze your environment, you can stay on top of health status as well as configuration information in easy to read layouts.

"The [SentryOne] visualization of AlwaysOn Availability Groups is quite helpful and being able to see the volume of data helps determine hot servers."

- DBA (TrustRadius reviewer)

AlwaysOn Monitoring with Performance Advisor

 

Availability Groups

 

SentryOne SQL Sentry can automatically monitor your AlwaysOn Availability Groups, giving rapid insight into the state of your environment. You have the ability to switch views into how Availability Groups are laid out – for example, by Windows Server Failover Cluster node, by SQL Server instances, and by Availability Group. Powerful visualizations of data flow and obvious color highlighting allow you to identify health issues quickly.

Tracking Key Metrics

 

SQL Sentry also tracks key metrics related to data being sent to and from replicas, as well as the send and redo queue, so that you know how your database synchronization process is performing. You can also track replica state changes and errors in the event of an Availability Group failover between replicas.

Alerting

 

Use the built-in conditions for alerting to notify you when replicas become unhealthy and Availability Groups failover. Alternatively, you can write your own alerts and responses using the powerful Advisory Conditions™ framework; for example, calculating whether all of the databases in an Availability Group meet your Recovery Time Objective (RTO).

SQL Monitoring

 

 The SQL Sentry Performance Analysis dashboard gives you the ability to see both high-level and detail-level metrics about your environment, right inside the client. Any DBA can see exactly what is happening in their environment in real time. With clear symbols marking which replicas are configured for automatic failover, read-only connections, or synchronous synchronization, you can answer both SQL Server performance and configuration questions as soon as you open SQL Sentry.