Overview First, we need to cover what distributed availability groups are. The basic definition is it an availability group of availability groups (AG). No remembering back to English class in school […]
In last part of the series, we will touch on how to monitor availability groups using extended events. I prefer this method over using SQL Agent alerts just because I […]
In my last post on monitoring Availability Groups I covered looking at Perfmon Counters now we take a look at getting alerts from SQL Agent. When it comes to checking […]
Monitoring Availability Groups can be tricky. The DMVs don’t update the log_send_rate and redo_rate all the time especially if nothing is happening so if you try to use those for calculations […]
Implement AlwaysOn Implement a mirroring solution using AlwaysOn Availability modes (http://technet.microsoft.com/en-us/library/ff877931.aspx) Asynchronous-commit mode Synchronous-commit mode Steps to perform Create mirroring endpoint (http://technet.microsoft.com/en-us/library/ff878259.aspx) Enable AlwaysON (http://technet.microsoft.com/en-us/library/ff878259.aspx) Create an availability group […]
Enter your email address to subscribe to this blog and receive notifications of new posts by email.