Open for Voting

Root Blockers Report

Although we can pick an hour and see details of all blocks, it would be handy to have a report to see what are the top blockers in the system. Root blockers don't usually appear on the waits page due to how they work. If a root blocker running for 2 mins blocks 10 executions of a different sproc, each lasting 30 seconds due to timeouts, the blocked sprocs total 300 seconds, but the root blocker is only 120 but is the cause for the waits.