Blog

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.

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

  2. 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.

  3. Pingback: Something for the Weekend – SQL Server Links 19/08/11

  4. Can you post the name of that “query trace” free tool you mentioned?
    Thanks

  5. 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?

  6. Pingback: Hint Abuse: SQL Server vs Oracle

  7. Any change we could get a transcript of this?

  8. 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!

  9. 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!

  10. Pingback: How to prevent blocking in your SQL Server database | James Serra's Blog

  11. Fantastic presentation guys. Very insightful.

Leave a Reply

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

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

css.php