Introduction
Installing and Configuring Database Health Monitor
Database Health Monitor
Monitoring Waits
Monitoring Blocking
CPU and Blocking by Hour of Day
Using the QuickScan Report
-
QuickScan Video Lesson (22:34)
-
Check for Untrusted Foreign Keys (4:00)
-
Check for Jobs Not Scheduled (1:04)
-
Large Differential Backups (2:04)
-
User Defined Assemblies in the Database (2:04)
-
UPDLOCK - Relating to Blocking and Waits (1:19)
-
SA Connections Active and Running (1:21)
-
Database Snapshot Warning (1:39)
-
SQL Server 2019 CU 27 - Error log issues (0:53)
-
Remote Query Timeout Too Low (0:41)
Other Instance Reports
Schema Search
Multi Instance Reporting
Other Reports
TempDB Reports
Congratulations
