How to find out the root cause of a deadlock on MSSQL

book

Article ID: 129057

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction



How to find out the root cause of a deadlock on MSSQL?

Environment

Release: CODFSS99000-15.4.1-PPM SAAS FedRAMP-Sandbox-Small Environment
Component:

Resolution

Check with your DBA team and provide the latest deadlock graph from the last occurrence of the deadlock.
 
Once you get this upload it to the case for our review.
 
More information can be found at
https://msdn.microsoft.com/en-us/library/ms190465.aspx
Save Deadlock Graphs (SQL Server Profiler)