Your SQL Server is slow, and you suspect blocking.
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
Each video in this course has English captions available, plus a transcript below the video.