List of performance-related alert types
Published 17 August 2020
Some SQL Monitor alerts are categorized as performance-related alerts. This categorization is useful when you are trying to suppress alerts through alert suppression windows.
Here is a list of all the performance alerts in SQL Monitor:
Host machine alerts
- Physical memory
- Processor under-utilization
- Processor utilization
SQL Server alerts
- Blocking process
- Custom metric collection error
- Database unavailable
- Deadlock
- Deadlock (extended event)
- Job duration unusual
- Long-running query
Availability group alerts
- Availability group – query slowdown
- Availability group – replication falling behind