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

DBA vs Deadlock: How to Out-Index a Deadly Blocking Scenario

 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 get the code to cause a sample deadlock in SQL Server.

You'll see how to interpret the deadlock graph to find out where the conflict lies, and how to design an index to make the deadlock disappear.

What you will learn

You'll leave the session with the steps you need to confidently tackle future deadlocks.

Speakers

Jason Hall and Kendra Little