Home Forums Article Discussions Article Discussions by Author Discuss content posted by Wayne Sheffield Locking, Blocking and Deadlocking RE: Locking, Blocking and Deadlocking

  • November 19, 2013 at 3:57 pm

    #1667619

    desperadomar (11/18/2013)

    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?

    Ummm.... No.

    The blocked by column is just that... the spid that is blocking this spid. Use a recursive CTE to keep going up this chain, until you find a blocked by that is empty. That one is the head blocker (for this chain of blocking).

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes

    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2