Understanding Database Locking and Blocking: 100% Demo - Part 4 (Deadlocks)


Length: 1 hour

One of the most pernicious problems within an RDBMS, like SQL Server or Azure SQL, are deadlocks. Deadlocks are a condition where two or more users vie for locks on resources exclusively locked by the other user at the same time. Because none of the users are willing to give up their exclusive locks and they all want exclusive locks on the other resources, no one wins. Even worse is that SQL Server must choose one of the user processes to kill in order to break the deadlock.

Deadlocks are often caused by poor index design or inattention to coding best practices. The good news is that deadlocks are easy to find and, once you know about them, easy to fix.

Join your host, Kevin Kline, and noted Microsoft MVP Torsten Strauss for this 100% demo session on deadlocks. In this session, you will see:

  • Examples of how deadlocks may occur
  • T-SQL scripts to reveal if deadlocks are happening
  • Xevents to monitor for deadlocks
  • Trace flags that help identify deadlocks
  • Queries to reveal the exact table(s) and record(s) that are deadlocked
  • And much more

Whether you're a dev or DBA, this webinar helps to remove the mystery behind why some applications are plagued by deadlocks and how to detect and remedy them. Learn these important techniques to detect and resolve deadlocks as you continue to advance your skills and level up as a SQL Server or Azure SQL technologist. Join us!

Interested in additional SentryOne webinars? Check our webinar library.

Register now

Kevin Kline

Kevin Kline

Principal Program Manager, SentryOne

Kevin (@kekline) serves as Principal Program Manager at SentryOne. He is a founder and former president of PASS and the author of popular IT books like SQL in a Nutshell. Kevin is a renowned database expert, software industry veteran, Microsoft SQL Server MVP, and long-time blogger at blogs.sentryone.com/author/kevinkline. As a noted leader in the SQL Server community, Kevin blogs about Microsoft Data Platform features and best practices, SQL Server trends, and professional development for data professionals.

Torsten Strauß

Torsten Strauß

Microsoft Most Valuable Professional and Data Platform Senior Consultant
Torsten Strauß (MVP, MCSE Data Platform, MCSE Data Management and Analytics, MCT) has been working with Microsoft SQL Server since the turn of the millennium. He currently works as Database Engineer and Microsoft SQL Server Evangelist for BP Europe SE and as Principal Consultant for Sarpedon Quality Lab. Torsten has delivered more than 100 presentations about Microsoft SQL Server at national and international conferences and user groups in recent years.

Companies with the highest demands for database performance choose SentryOne