This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

little confused about the blocking issue.

I am a little confused about the blocking issue. I see the idle blocker with SPID XXX with no information or detail and the same SPID is blocked as well. This SPID id is idled since morning. What confuses me is that when I run sp_who2 or generate a report from the activity monitor, I see no blocking and this is what's confusing.