Wait Types – LCK% – Locking Snapshot RCSI Part 2 (29 minutes)

There are 3 ways to fix blocking problems. We’ve covered indexes, and now we’ll cover shorter transactions and changing isolation levels.

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.