Options

Blocking spid?

mfalmfal Posts: 19
edited September 26, 2011 6:04PM in SQL Monitor Previous Versions
I'm new to the tool and have been poking around with some of the alerts. When blocking processes occur, where can I find the blocking spid id? I can find the blocking process name, but when I have an application using multiple spids, the blocking process name is not helpful. What am I missing?

Comments

  • Options
    Hi

    On the details page of the Blocked Process alert there is a tab called Processes that contains a "Process ID" value. This I believe is the spid id that you're looking for.

    Chris
    Chris Spencer
    Test Engineer
    Red Gate
  • Options
    Thanks, I found it. If possible, for future releases, it would be nice to see the full blocking chain in a screen. I'm used to seeing that in other utilities.
Sign In or Register to comment.