How to Create Deadlocks and Troubleshoot Them

Watch in awe and wonder as Brent Ozar creates a deadlock, then uses sp_BlitzLock after the fact to show you which queries and tables were involved.

Generate Deadlock Summary Information

This article will show you how to extract a summary of tables affected by deadlocks.

Extracting only Deadlock details from ErrorLog

If you want to extract only deadlock details, use the script.

SQL Server Deadlocks by Example

In this article, Gail Shaw looks at how you can identify common types of deadlock, the difference between a deadlock and severe blocking, and how to avoid and fix the most common deadlock types.

Handling Deadlocks in SQL Server

In this excerpt from his book Troubleshooting SQL Server: A Guide for the Accidental DBA, Jonathan Kehayias provides a guide to identifying the causes, reacting to, and ultimately preventing the dreaded deadlock.

Deadlock

Catching Deadlock Information in SQL Logs

This article presents a handy way to retrieve deadlock information in an ordered way from the error log.

How to receive Deadlock information automatically via email

Receive Deadlock info from the SQL Error Log every time a deadlock occurs.

DEADLOCK & traceflags!

View Deadlock Graphs

View information about the deadlocks captured to a trace file.