What?! SELECT query caused a deadlock?

What?! SELECT query caused a deadlock?

deadlockVideoDeadlocks. We all know a lot about them, right? A sample scenario is simple - one process (A) deadlocks with another one (B) when they acquire locks in a different order. A waits on B and B waits on A. One of them has to be killed to resolve the situation. Is that all? Not really. If you work with SQL Server you might have experienced a deadlock when one of the processes was executing a SELECT query and nothing else. It is surprising at the first glance, but actually it makes sense. Watch my video explanation.

If you are more interested in deadlocks, you might want to know how to check deadlock details in SQL Server.

Would you like to learn db performance? Enroll to my course on Udemy.

Promo code: PERF_OPT_0522

liquibase course promo

We use cookies

We use cookies on our website. Some of them are essential for the operation of the site, while others help us to improve this site and the user experience (tracking cookies). You can decide for yourself whether you want to allow cookies or not. Please note that if you reject them, you may not be able to use all the functionalities of the site.