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

Article Id: 129057

Status: Published

Updated On: 08-03-2019 13:31

Products:

CLARITY PPM FOR ITG , Clarity PPM On Premise , CLARITY PPM FEDERAL , Clarity PPM SaaS , Clarity PPM SaaS - Application , Clarity PPM SaaS - Application , 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)