Monitoring and Alerting of Availability Groups

So you have your Availability Groups (AG) configured and everything reports green. Learn how to measure for Service Level Agreement (SLA) compliance! Know when replication is delayed! Get notified when a failover occurs! In this session, we will teach the attendee how to implement proper monitoring and alerting. We will also show you what metrics and reports you should be reviewing regularly to ensure there are no surprises, such as pauses replication or unacceptable delays. For example, we will look at the DMVs, extended event sessions, perfmon counters, SQL agent jobs and alerts. We will show what to monitor in your AG, and how to setup alerting so you know when to take action.

Presenter:

  • Shawn Meyers, Principal Architect

Download Now

Monitoring and Alerting of Availability Groups

So you have your Availability Groups (AG) configured and everything reports green. Learn how to measure for Service Level Agreement (SLA) compliance! Know when replication is delayed! Get notified when a failover occurs! In this session, we will teach the attendee how to implement proper monitoring and alerting. We will also show you what metrics and reports you should be reviewing regularly to ensure there are no surprises, such as pauses replication or unacceptable delays. For example, we will look at the DMVs, extended event sessions, perfmon counters, SQL agent jobs and alerts. We will show what to monitor in your AG, and how to setup alerting so you know when to take action. Presenter: Shawn Meyers, Principal Architect