Troubleshooting Blocking and Deadlocks for Beginners

Rated 5.00 out of 5 based on 12 customer ratings
(12 customer reviews)

$99.00 for 2 years

Learn to easily configure free blocking monitoring tools, identify which queries are slowing you down, and untangle deadlocks.

Out of stock


Your SQL Server is slow, and you suspect blocking

You need to prove if blocking is killing the performance on your SQL Server. Learn to set up simple, lightweight monitoring using free tools and scripts to find the queries causing your blocking and deadlock problems.

You get two hours of training videos, online quizzes, and sample interview questions in this online course.

Course modules:

  • Welcome! Here’s what you need to get started (2 minutes)
  • Wait stats, alerts, and troubleshooting blocking live (43 minutes)
  • Troubleshooting blocking that happens when you’re away from your desk (31 minutes)
  • Capture and prevent deadlocks (29 minutes)
  • Interview questions (21 minutes)
  • Learning plan (3 minutes)

Lessons in these modules are each between 5 and 15 minutes on average, so you can easily move through the course in short sessions.

Not sure if it’s right for you? Browse the course modules and preview the first two videos in the course.

Note: you won’t see quizzes in preview mode: you only get those after you register for the course and log in.

12 reviews for Troubleshooting Blocking and Deadlocks for Beginners

  1. Rated 5 out of 5

    Louis (verified owner)

    You’re session on Troubleshooting Blocking and Deadlocks for Beginners ROCKED, I really like the way you walked us thru the process on how to catch Blocking and Deadlocking. I also really liked the way you formatted/paced each session and the Q&A part was awesome. Looking forward to your next session. Great job with the session, keep up the good work.

  2. Rated 5 out of 5

    Heather (verified owner)

    Great format! Found it very helpful to get an overview of the tools for both blocking & deadlock capturing, both native SQL Server as well as outside tools to track & troubleshoot the issues. The break between stating the problem & the answer video was also a good setup for learning to troubleshoot on our own.
    Looking forward to more classes!

  3. Rated 5 out of 5

    Mike (verified owner)

    Decent content & a great format. It’s so much more engaging having the code to run yourself rather than other courses which are essentially extended conference talks with no involvement

  4. Rated 5 out of 5

    Siva (verified owner)

    Thank you so much Kendra. Your course on deadlocks and blocking is very informative and easy to follow. A great start for the beginners. I would highly recommend this to get started.

    Keep up the great work and for providing lots of free and useful tools for us.

  5. Rated 5 out of 5

    josh (verified owner)

    Kendra has broken down this topic into a bunch of easily digested segments and provided all the demo code so you can follow along at home (or the office). Recaps, segment quizzes and practice interview questions allow for the sort of engagement with the material that increases the odds that you’ll be able to recall it later when you really need to. Highly recommended!

  6. Rated 5 out of 5

    Stephen (verified owner)

    Great course. Having been an accidental DBA for a year now and dealing with locking / blocking / deadlocking on production systems this course gave me the confidence that I was on the right path and gave me more insight to what else I can cover. Great format, well presented. Thoroughly enjoyed it. Thanks Kendra.

  7. Rated 5 out of 5

    nkhalilbayli (verified owner)

    Great thanks Kendra! As a Junior DBA, I have learned so much from this course. Will wait for new courses from you!

  8. Rated 5 out of 5

    Ian (verified owner)

    A wonderfully clear and reassuring way to learn or refresh your blocking / locking skills.

  9. Rated 5 out of 5

    happysorin (verified owner)

    Super fun and a great way to learn about locking/blocking and deadlocks in SQLserver. I highly recommend it!

  10. Rated 5 out of 5

    andrew.kopittke (verified owner)

    A great introduction to locking, blocking and deadlocks. The practical examples and scripts make this really easy to follow along and get experience in troubleshooting in a controlled way.

  11. Rated 5 out of 5

    ShivashankarKN (verified owner)

    Fantastic and refreshing course… thank you !

  12. Rated 5 out of 5

    benson sibanda (verified owner)

    Excellent presentation. I didn’t have proper ways of dealing with Locking and deadlocks. I will certainly apply the things I have learnt very soon.

Add a review

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

You may also like…