Deadlocking for Mere Mortals

YouTube·PASS Data Community Summit

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.