Wait Types – LCK% – Locking Snapshot RCSI Part 1 (39 minutes)

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. In this module, Brent demonstrates locks, blocks, lock escalation, how to use indexes to avoid lock escalation,…