Five Ways to Fight Blocking Video

What do *you* do when your database has a problem with blocking? Most people reach for the “NOLOCK” hint. Bad news: that may introduce other problems, and it doesn’t truly resolve the root problem in your application code. In this video Kendra Little summarizes five big-picture application changes that fight blocking long term.

This 300 level talk is designed for developers and DBAs who understand table structures, index structures, and common query patterns. We’re going to keep things general: no demos, just concept discussions.

Learn more about isolation levels in our resources page.

Previous Post
Consulting Line: “What problem are we trying to solve?”
Next Post
Even Simple Changes Can Cause Trouble: A Tale of TempDb

16 Comments. Leave new

  • AndyG @DBA_ANDY
    August 17, 2011 10:16 am

    How about recording the webex’s and actually posting them on the site rather than just linking to webex? (Or does that violate your agreement with webex?)

  • I winced when I heard that triggers are often employed to do auditing. Why do vendors and developers refuse to use the database’s auditing feature to do this?

    I’m guessing you said that because you see it so much…

    I loved your presentation style and format. It allowed me to follow along without feeling really stupid as there was no T-SQL code for me to digest.

  • Can you post the name of that “query trace” free tool you mentioned?

  • Great video. A neophyte needs all the help he can get. However, I’ve identified the bottlenecks, but am not sure of the code needed. Question about “read from secondaries”- will a view work as a secondary?

  • Any change we could get a transcript of this?

  • Thanks Kendra. Interesting approach – and the drawings are really great. I have to say, however, I would have gotten a lot more out of this session with some example code/demo. The strategies on their own, do seem a bit like “motherhoods”. How about a follow-up session?

    • Hi Tim–

      Glad you liked it. Doing demos of each of these would be lots of fun–I could do quite a few webcasts diving into each one of these, showing more about how it works, and comparing and pros and cons of different methods. Thanks for the feedback and I’ll put ideas on them into the hopper!

  • Bill Preachuk
    August 26, 2011 2:14 pm

    Thanks Kendra. That was a terrific talk. I like how your format allowed you to present many ideas without diving into painful detail on each. I appreciate *not* receiving a lot of T-SQL and code samples sometimes.

    Well done and Thanks again!

  • Fantastic presentation guys. Very insightful.


Leave a Reply

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

Fill out this field
Fill out this field
Please enter a valid email address.