Deadlocks due to Hash Collision

Apart from discussing about troubleshooting a rare deadlock condition, James Rowland-Jones, in one of his most popular articles, illustrates a lot of fundamentals about deadlock troubleshooting and SQL server lock manager in his post The Curious Case of the Dubious Deadlock and the Not So Logical Lock

I strongly recommend you to read this relatively lengthy article and also follow the comments in the post.

This post is part of the series SQL Server deadlocks and live locks – Common Patterns. If you have questions, please post a comment here or reach me at @sqlindian

Leave a comment

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: