Blocking Processes
This alert checks for blocked process and triggers an alert when the blocked processes are exceeding a certain number and/or wait duration (expressed in milliseconds).
By default, the check runs every minute, but notifications are sent out based on the [repeat_notification_interval] setting (at the alert level, expressed in minutes).
The SQL Agent job implementing this check is called "dba - alert blocking".
The threshold for this alert is set in the DBADashExt database and is independent of the ones defined in the DBADash configuration tables.
The first step in troubleshooting this alert is to check the Performance Summary tab in the DBADash tool for the affected server look at the Blocking chart. If you see bubbles, it's troubles.
More info on the blocking topic:
- Adam Machanic's sp_WhoIsActive blog -- blockers
- Adam Machanic's sp_WhoIsActive blog -- why am I blocked
- Adam Machanic's sp_WhoIsActive blog -- why am I blocked
This is a sample alert:
