SQL Server Deadlock Troubleshooting with SQL Profiler

Leave a comment

One method to troubleshoot SQL Server Deadlocks is to use the SQL Profiler.

In SQL Profiler, in a new trace, select the Events Selection tab and expand Locks:

Select the Deadlock graph:

Run the code that causes a deadlock. In profiler, you will now see a line for the Deadlock graph. Selecting it will show the graph with the process that succeeded and did not succeed:

Hovering over the graph shows the SQL trying to be executed:

 

ABOUT CARL DE SOUZA

Carl de Souza is a developer and architect focusing on Microsoft Dynamics 365, Power BI, Azure, and AI.

carldesouza.comLinkedIn Twitter | YouTube

 

Leave a Reply

Your email address will not be published. Required fields are marked *