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

This entry is part 3 of 3 in the series Monitoring Availability GroupsIn 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 …

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

This entry is part 2 of 3 in the series Monitoring Availability GroupsIn 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 …

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

This entry is part 1 of 3 in the series Monitoring Availability GroupsMonitoring 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 …

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

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) …

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