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.
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?)
Andy – err, I’m not sure what you mean. The video’s viewable right here on BrentOzar.com. What additional capabilities are you looking for?
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.
@hillbillyToad – well, the auditing feature requires Enterprise Edition – so that’s around $20k/cpu socket to implement. Triggers are free. 😀
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?
Caruncles – no, a secondary means a second SQL Server.
Any change we could get a transcript of this?
Anon – unfortunately we don’t offer transcripts.
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?
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!
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.