Defuse the Deadlock SQLChallenge (23 minutes)

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)