• Thanks for the info ,I will give it a try to sp_whoisactive, but when you use sp_who2 I can only see some spid's in the

    blocked by

    column so all that spids in that column are head blockers?