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,…

To access this incredible, amazing content, you gotta get Fundamentals of Server Tuning with Wait Stats or Recorded Class Season Pass, or log in if you already shelled out the cash.