The Secrets to Monitoring SQL Server Availability Groups (AG) featuring Surveillance DB
Our host business partner MB Foster presents Bradmark's Edward Stangler as he explores monitoring for SQL Server AlwaysOn Availability Groups (AG), the critical HA and DR database feature in SQL Server 2012 and later.
A replacement for Database Mirroring, AGs provide a robust replication and failover capability for SQL Server, built atop Windows Clustering technology. This technical session will detail monitoring of latency, throughput, and status of Availability Groups.
Mr. Stangler details what kind of alerts are possible, how to use DM views and perfmon statistics to monitor performance and some of the pitfalls of monitoring AGs from SQL Server 2012 through 2017.