Sharpen your skills at fighting blocking and deadlocks.
You are equipped with scripts and a video showing you how to reproduce a deadlock, plus a copy of the deadlock graph.
Your challenge: design an index that prevents the deadlock from happening when the repro steps are run again
After you’re done working on preventing the deadlock, watch the videos showing how I strategized the solutions, and indexes I tested that prevent the deadlock (you get these, too, in the solution script).
Worried you’ll get stuck?
Getting stuck is totally OK - it’s the struggle that gets you there in the end!
If you get totally frustrated, go ahead and watch the solution videos. ThenĀ set yourself a reminder to retake the challenge in one week’s time. Running through the challenge again will lock in the learning.
Get the scripts
https://github.com/LitKnd/SQLWorkbooks/tree/main/defuse_deadlock_sqlchallenge
Lessons
Demo: How to Reproduce the Deadlock (6 minutes) |
Demo: Defusing the deadlock (10 minutes) |
Strategizing how to defuse the deadlock - and where the graph tells a lie (7 minutes) |