From the course: Microsoft Azure Database Administrator Associate (DP-300) Cert Prep by Microsoft Press

Unlock this course with a free trial

Join today to access over 25,500 courses taught by industry experts.

Monitor an HA/DR solution

Monitor an HA/DR solution

From the course: Microsoft Azure Database Administrator Associate (DP-300) Cert Prep by Microsoft Press

Start my 1-month free trial Buy for my team

Monitor an HA/DR solution

“

- Welcome back. This is lesson 15.7, monitor a high availability disaster recovery solution. Monitoring a high availability and disaster recovery solution really depends on the solution and what tools you're familiar with, but let's start with always on availability groups. You have several options available to monitor an always on availability group. The first and easiest is the Availability Group Dashboard built right into SQL Server Management Studio. Right click on the Availability Group in SQL Server Management Studio and select Show Dashboard. This presents a nice dashboard that shows the overall health and status of the availability group. One of the things that I wished it showed by default is the RPO and RTO, the Recovery Point Objective and Recovery Time Objective of the availability group. But you can view this by clicking the Add/Remove Columns link in the upper right of the dashboard, and add the estimated recovery time and estimated data loss columns, which give you…

Contents