Multi-victim deadlocks – a simple example

(Linchi Shea) Recently, I ran into a series of deadlocks that had multiple victims in each deadlock. In other words, SQL Server chose more than one spid to terminate in resolving a deadlock.

Read More - Register for Free Membership