Blocking: How to Find and Fight LCK* Waits

When you’re facing lock waits and blocked queries, it’s tempting to just slather NOLOCK all over the queries. Thing is, this won’t necessarily fix it, and there are much better ways to track, diagnose, and cure blocking issues. You’ll learn them here.

Brent Ozar

I make Microsoft SQL Server go faster.

Las Vegas, Nevada, United States


Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.

Jump to top