-
Notifications
You must be signed in to change notification settings - Fork 0
Blocking Duration
alinselicean edited this page Feb 13, 2023
·
2 revisions
By default, process 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:
This is still work-in-progress