Deadlocking for Mere Mortals

Explore the intricacies of deadlocking in SQL Server through this comprehensive conference talk. Delve into common deadlock scenarios frequently discussed in online forums and master various troubleshooting techniques available to database administrators. Learn about Trace Flags, SQL Trace, Event Notifications, and Extended Events as powerful tools for resolving deadlocks. Gain insights into key concepts such as lock types, lock escalation, lock compatibility, and the Lock Monitor Thread. Understand deadlocking priority, victim selection, and the importance of SQL Server Trace Flags. Discover how to leverage legacy trace flags, event notifications, and extended events for effective deadlock analysis and resolution.

Introduction
About Jonathan
Overview
Misconceptions
Terminology
Lock Types
Lock Escalation
Lock Compatibility
Whats a Deadlocking
Lock Monitor Thread
Deadlocking Priority
Deadlocking Victim
SQL Server Trace Flags
Legacy Trace Flags
Event Notifications
Tracing and Extended Events
Victim Process
Resource List
Process List