Avoiding Deadlocks by Query Tuning
04/29/2025
11:00 AM CDT | 9:00 AM PDT
Online
Deadlocks can be one of the most frustrating and disruptive issues SQL Server DBAs and developers face—especially when they strike at peak business hours. While index tuning is often the first line of defense, query tuning is just as critical in preventing these concurrency conflicts.
In this live session, renowned SQL Server expert Brent Ozar will walk you through the underlying causes of deadlocks beyond indexing issues, with a specific focus on query behavior and transaction design. You’ll learn how long-running transactions and inconsistent access patterns across tables can trigger deadlocks, and more importantly, how to fix them. Brent will demonstrate why working through tables in a consistent order and minimizing touches per table are key to reducing conflict—and how small adjustments in query design can make a huge impact on performance and reliability.
The session will include a real-world deadlock example, followed by a live query rewrite to resolve the issue. Whether you're a DBA or developer, you'll walk away with practical strategies you can apply immediately to make your queries deadlock-resistant and your applications more resilient.
👉 Can’t make it live? Register now, and we’ll send you the recording to watch at your convenience.