Monitor AlwaysOn Availability Groups with Performance Advisor

Visualize your SQL Server AlwaysOn environment in a whole new way. 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.

Give Performance Advisor AlwaysOn Availability Group Monitoring a try for yourself with a free 15-day trial.

Let's get started

“The more that I use SQL Sentry, the more I fall in love with it. #SQLSentry #LoveStory”

John Morehouse

What are SQL Server AlwaysOn Availability Groups?

Always On Availability Groups are a high-availability and disaster-recovery feature introduced with SQL Server 2012, providing enhancements and abilities over database. 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.

AlwaysOn Monitoring with Performance Advisor

SentryOne Performance Advisor can automatically monitor your 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.

Performance Advisor also tracks key metrics related to data being sent to and from replicas, along with 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.

Use the built-in conditions for alerting 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; for example, calculating whether all of the databases in an Availability Group meet your Recovery Time Objective.

SentryOne Performance Advisor 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 performance and configuration questions as soon as you open Performance Advisor.

LOOKS LIKE YOUR BROWSER IS OUT OF DATE

For your convenience here are links to supported browsers:

Your browser could be incompatible with this website.
If you close this window and continue you may experience less than optimal behavior.

Don't show this again