AlwaysOn Availability Groups Troubleshooting and Monitoring Guide published!

AlwaysOn Availability Groups Troubleshooting and Monitoring Guide provides information on troubleshooting the common AlwaysOn Availability Groups issues and monitoring the availability group health. We will try to keep updating this guide as new troubleshooting scenarios are documented so that you can conveniently find all the information in one place. Please send us feedback on it!


Monitoring AlwaysOn Health with PowerShell – Part 4 : Integration with SQL Server Agent

Part 4 – Scheduling and Notification with SQL Agent In Part 3, we introduced the problem of automatically monitoring our availability group.  We made some progress, developing a simple script that evaluates the health of an AG on a given server instance, and throws an error when the AG is a state warranting investigation.  We now…


The AlwaysOn Health Model Part 1 — Health Model Architecture

After successfully deploying a high availability solution using SQL Server 2012 AlwaysOn, monitoring and maintaining its health is critical.  In this post, we’ll give an overview of the health model used by the AlwaysOn Dashboard and PowerShell cmdlets to support these monitoring scenarios.  This is part 1 of a multipart series looking at the AlwaysOn…