14,500 questions
That all depends on the nature of the deadlock. There is no generic answer to the question. If you have a specific deadlock, share the deadlock XML.
How to resolve deadlocks practically fast?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 32%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECK%3C/text%3E%3C/svg%3E)
Chaitanya Kiran
101
Reputation points
How to resolve deadlocks practically fast?
SQL Server | Other
2 answers
Sort by: Most helpful
-
Erland Sommarskog 121.9K Reputation points MVP Volunteer Moderator2021-05-12T21:42:48.35+00:00 -
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 78%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECZ%3C/text%3E%3C/svg%3E)
Cris Zhan-MSFT 6,661 Reputation points2021-05-13T06:22:26.227+00:00 Hi,
Deadlock and blocking are the products of SQL Server to complete transaction isolation. To solve the deadlock, it is very important to find the resources that the two parties (or multiple parties) of the deadlock compete for together. The deadlock problem requires specific analysis and positioning before making corresponding measures, rather than adopting general solutions.