Monitoring and Alerting of Availability Groups

Presented by

Shawn Meyers, Principal Architect

About this talk

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.

Related topics:

More from this channel

Upcoming talks (0)
On-demand talks (30)
Subscribers (3407)
The combination of leadership by OpsCompass in the Cloud Security Posture Management (CSPM) space, and thought leadership by House of Brick regarding virtualization and cloud computing for enterprise applications enables even better, more meaningful, solutions for clients. <p> OpsCompass’ SaaS product drives operational control, visibility, and security in and across cloud platforms including Microsoft Azure, Amazon Web Services (AWS), Office 365, and Google Cloud. To learn more, visit</p> <p>House of Brick Technologies provides leadership in the optimization of business-critical systems, with a focus on Oracle, Microsoft, AWS, and VMware-based workloads. Offerings include cloud and virtualized architecture optimization, high availability and disaster recovery strategies, application re-platforming and data migration, and license compliance consulting. To learn more, visit</p>