Deadlocks strike fear into the hearts of even seasoned DBAs—but they don't have to! In this session, you'll be provided with the code to create a sample deadlock in SQL Server. You'll learn how to interpret the deadlock graph to pinpoint where the conflict occurs, and how to design an index to eliminate the deadlock. By the end of the session, you'll have the confidence and knowledge to tackle future deadlocks effectively.
Topics that will be discussed include:
- Creating and analyzing a sample deadlock in SQL Server
- Interpreting the deadlock graph to identify conflict points
- Designing indexes to resolve and prevent deadlocks
- Practical steps for confidently addressing future deadlocks
Speakers:
- Jason Hall, SQL Server Expert
- Kendra Little, SQL Server Expert
What you will learn