Exploring Deadlocks

  • Comments posted to this topic are about the item Exploring Deadlocks

    Robert W. Marda
    Billing and OSS Specialist - SQL Programmer
    MCL Systems

  • For my developers who are reticent to dive into Books Online (including on MSDN) but are willing to go a web page, I now have a resource.

    K. Brian Kelley

    bkelley@sqlservercentral.com

    http://www.sqlservercentral.com/columnists/bkelley/

    K. Brian Kelley
    @kbriankelley

  • I'm glad my article can help. I try to give examples that can be run by anyone so that what I explain in them can be tested by anyone. This is not always done in Books Online. And this is no way to put down Books Online. I use it extensively and have learned a lot from it; however, good sample code can often help to understand what is being explained.

    Robert Marda

    Robert W. Marda
    Billing and OSS Specialist - SQL Programmer
    MCL Systems

  • Interesting, though I'd like to see more detail - what a deadlock looks like in the error log and how to decipher it would be good. Ultimately you cannot avoid deadlocks entirely. Applications MUST trap for them and resubmit the query.

    Andy

  • Also it would be nice to explain what trace flags you can turn on in SQL to catch those dead of night deadlocks that sometimes occurr. I have to say though that for a newbie this is a nice article for others it is a rehash of other items they have probably seen. Get into more details about deadlocks and how to pinpoint why, where, and when they occurr.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

  • I will consider doing another article about deadlocks. In this article I focused on examples to make it easy for anyone to create and see deadlocks in action. Usually, you only see the error message and at that point the deadlock is gone and there is nothing to see. Also, I have not worked much with trace flags yet, and so can't say much about them yet.

    Robert Marda

    Robert W. Marda
    Billing and OSS Specialist - SQL Programmer
    MCL Systems

  • Look out Robert, looks like you're getting in the same situation I'm in... you write an article that produces thought and there are clamors for a follow-up! It's a great situation to be in, though.

    K. Brian Kelley

    bkelley@sqlservercentral.com

    http://www.sqlservercentral.com/columnists/bkelley/

    K. Brian Kelley
    @kbriankelley

  • Yes it is. Looking forward to a followup!

    Steve Jones

    steve@dkranch.net

  • Well it won't happen real soon due to the fact that I'll need to learn more plus I just submitted part 1 of a 2 part article and so must finish part 2 of that one.

    Robert Marda

    Robert W. Marda
    Billing and OSS Specialist - SQL Programmer
    MCL Systems

  • Well, I will be looking for it. And you'll love those trace flags, they give quite a bit of detail based on which ones you use.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply