You keep getting warnings and emails about deadlocks, but let’s be honest: you’re not really sure how they happen or what to do about it. In this one-hour session from the SQLBits conference, I will show one, use sp_BlitzLock to analyze it, then fix it.
If you like this video, check out the SQLBits YouTube channel. They’re releasing all of last year’s conference videos online for free in YouTube! When you subscribe to their channel, you’ll automatically get notifications as new videos get uploaded.
Great session. Always educational, always humorous!
Thanks, glad you liked it!
Loved the content ! I’m downloading the plan explorer today
Not a whole lot you can do with Vendor applications, is there?
There is indeed! You can do index tuning and change the database’s isolation level, and I talk about how to do those with vendor apps in my Mastering Index Tuning and Mastering Server Tuning classes.