Deep Dive into Blocking and Deadlocks Troubleshooting

Dive deep into SQL Server's Concurrency Model and learn how to troubleshoot blocking issues and deadlocks in this comprehensive conference talk. Explore the often misunderstood aspects of SQL Server Internals, focusing on lock types, their lifetime, and compatibility. Gain a structured understanding of why blocking and deadlocks occur unexpectedly and how they impact system performance and user experience. Learn to analyze these issues from multiple perspectives and discover effective troubleshooting techniques using standard SQL Server tools. Get introduced to the Blocking Monitoring Framework developed by Dmitri Korotkevitch, which simplifies the analysis process. This 75-minute session, originally presented at PASS Summit 2019, provides valuable insights for SQL Server professionals looking to enhance their troubleshooting skills and optimize database performance.