Identify head blocker in a blocking chain
It would be quite useful and timesaving if one could identify the head blocker for a blocked process (as done in SSMS's Activity Monitor, Processes tab). Otherwise when get a lot of blocked process alerts, you have to manually figure out the head blocker by analysing all the alerts.
Oftentimes it happens to be Red Gate SQL Backup that is the Blocked Process. I'd really like to QUASH any Blocked Process Alerts when this is the case... Having to spin my wheels working out that a backup is the problem isn't helping me with REAL issues - if I get a Failed Backup, THEN I'm interested. +3 votes...
Thanks for your feedback. We will investigate this.