Create and capture a deadlock (9 minutes)

The best way to learn to capture deadlocks is practice. I'll show you re-runnable code that you can use to cause a deadlock in WideWorldImporters, then show you how to capture the deadlock graph with an Extended Events trace. Prefer to use a server side SQL Trace? That's OK, I've got sample code for that, too!

Back to: Troubleshooting Blocking and Deadlocks for Beginners (2 hours 10 minutes) > Capture and prevent deadlocks