• Bart Duncan's SQL Weblog

    Deadlock Troubleshooting, Part 1

    • 79 Comments
    A deadlock is a circular blocking chain, where two or more threads are each blocked by the other so that no one can proceed. When the deadlock monitor thread in SQL Server detects a circular blocking chain, it selects one of the participants as a victim...
  • Bart Duncan's SQL Weblog

    Deadlock Troubleshooting, Part 3

    • 44 Comments
    Here’s an example of the classic scenario that is usually used to introduce the concept of a deadlock in a database: Process A Process B 1. Begin Transaction 1. Begin Transaction ...
  • Bart Duncan's SQL Weblog

    Deadlock Troubleshooting, Part 2

    • 4 Comments
    In this post I’ll look at an actual deadlock, then troubleshoot it using the steps I described in Deadlock Troubleshooting, Part 1 so you can see them in action. This is a simplified version of a deadlock scenario that an internal customer here at Microsoft...
Page 1 of 1 (3 items)