How to find out the root cause of a deadlock on MSSQL
book
Article ID: 129057
calendar_today
Updated On:
Products
CLARITY PPM FOR ITG
CLARITY PPM FEDERAL
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)
Feedback