For the best web experience, please use IE11+, Chrome, Firefox, or Safari

Database Training Days 201: How to Out-Index a Deadly Blocking Scenario with Kenra Little and Jason Hall

 DBA vs Deadlock: How to Out-Index a Deadly Blocking Scenario
On Demand
  • Recorded Date:Jun. 14, 2018
  • Event:On Demand
 DBA vs Deadlock: How to Out-Index a Deadly Blocking Scenario

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

Watch Your Free Webcast

Please wait...

triangle-down check
By downloading, you are registering to receive marketing email from us. To opt-out, follow steps described in our Privacy Policy.

reCAPTCHA protects this site. See Google's Privacy Policy and Terms of Use.