Category: High Availability/Disaster Recovery

Monitoring Availability Groups Part 3 – Extended Events

This entry is part 3 of 3 in the series Monitoring Availability Groups

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 don’t like relying on the individual servers to send me emails.  I like to have our central monitoring server send out alerts based on queries …

Read More “Monitoring Availability Groups Part 3 – Extended Events”

Monitoring Availability Groups Part 2 – SQL Agent Alerts

This entry is part 2 of 3 in the series Monitoring Availability Groups

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 on your Availability Groups one of the easiest ways to keep track at a high level of the health of the them is to setup …

Read More “Monitoring Availability Groups Part 2 – SQL Agent Alerts”

Monitoring Availability Groups Part 1 – Perfmon Counters

This entry is part 1 of 3 in the series Monitoring Availability Groups

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 when monitoring you could false results worse yet pages in the middle of the night.  In order to calculate the log_send_rate and redo_rate you need to …

Read More “Monitoring Availability Groups Part 1 – Perfmon Counters”

Exam 70-458 – Objective 3 – Implement high availability

This entry is part 3 of 8 in the series Exam 70-458

  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 (http://technet.microsoft.com/en-us/library/ff878307.aspx) ALTER AVAILABILITY GROUP GroupA ADD DATABASE DB Create an availability group listener (http://msdn.microsoft.com/en-us/library/hh213080.aspx) Add a secondary replica (http://technet.microsoft.com/en-us/library/hh213078.aspx) ALTER DATABASE db SET HADR AVAILABILITY …

Read More “Exam 70-458 – Objective 3 – Implement high availability”