Chapter 5
Managing AlwaysOn Availability Group
Section 5
Monitoring AlwaysOn Availability Groups
Monitoring an AlwaysOn availability group is important to quickly find problems before or when they occur, and then take corrective actions. Monitoring an AlwaysOn AG can be done using the AlwaysOn dashboard, T-SQL, PowerShell, Performance Monitor, or other third-party monitoring tools. In this section, you will learn about the following: - The AlwaysOn Availability Group Dashboard - Collecting Latency Data Using the AlwaysOn Availability Group Dashboard - The SQL Server Agent Job - Configuring Reports - Primary Replica Latency Report - Secondary Replica Latency Report - Monitoring Availability Replica States - Monitoring Availability Database’s Synchronization Status - Monitoring the AlwaysOn Availability Group Current Workload - Monitoring an AlwaysOn Availability Group Using Power Shell