Opinions expressed on this site are solely those of Kendra Little of Catalyze SQL, LLC. Content policy: Short excerpts of blog posts (3 sentences) may be republished, but longer excerpts and artwork cannot be shared without explicit permission.
on May 22, 2018
DBA vs Deadlock: How to Out-Index a Deadly Blocking Scenario
June 14, 2018 8:30 AM – 9:30 AM PST <- This is past, but no worries, it was recorded
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.
You’ll leave the session with the steps you need to confidently tackle future deadlocks.