Head Blocker

Thanks Tara! It's been quite a while since I've posted a question. Nice talking again :smile: - You've always been a Great help!

I ran both of those but I didn't see how to find the head blocker from the output.

sp_WhoIsActive
I see the "blocking_session_id" column and in that column I see multiple id numbers, but also see 6 that are NULL which I'm guessing means there isn't anything blocking it.

However - The 6 NULL show different names for login_name, host_name, and database. So I'm unsure how to find the "head" blocker from this.

sp_who2
Here I see BlkBy which is fine. But the head blocker isn't blocked and therefore the head blocker isn't indicated.

I remember way back there was a script that showed both BlkBy and Blocking so when you located the SPID that was blocking but not blocked by ... well you had your offender.

Sorry if I'm missing something simple ... which is likely the case.

Regards,
Terry