Monitoring Availability Groups Part 2 – SQL Agent Alerts

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

This entry is part 2 of 2 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 1 – Perfmon Counters

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

This entry is part 1 of 2 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 »

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 »