Troubleshooting Blocking and Deadlocks for Beginners (2 hours 10 minutes)

Your SQL Server is slow, and you suspect blocking.

Try the course quizzes anytime: blocking diagnosis, troubleshooting retroactively, deadlocks

You need to prove if blocking really is the culprit and set up simple, lightweight monitoring using free tools and scripts to find the queries causing your blocking problems.

This practical course teaches you to fight blocking and deadlocks

Learn to tackle blocking problems strategically, understand the different DMVs that report lock waits – and when they update with lock information, get demo scripts to practice implementing solutions yourself, and take quizzes to test your knowledge along the way.

Get the scripts

https://github.com/LitKnd/SQLWorkbooks/tree/main/troubleshooting_blocking_and_deadlocks_for_beginners

Each video in this course has English captions available, plus a transcript below the video.

Lessons