2.4 How to Fix Blocking Waits (LCK%)

In the blocking, locking, and deadlocking modules in Mastering Index Tuning and Mastering Query Tuning, I covered how to fix those problems with index & query changes. Another solution is to make database-level changes like the default isolation level or offloading reads to another server with techniques like log shipping, replication, or Availability Groups.

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

Menu