I suggest you ...

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.

50 votes
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Blaž DakskoblerBlaž Dakskobler shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    2 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...
      • StephenStephen commented  ·   ·  Flag as inappropriate

        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...

      Feedback and Knowledge Base