ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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 / SQL Server?

Environment

Release: Any

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 Microsoft Support site: Save Deadlock Graphs (SQL Server Profiler)