2.6 Lab 4: Solving Blocking with Indexes – Brent Does It

We’ve got blocking! LCK% is dominating our wait stats, and tools like sp_WhoIsActive and sp_BlitzFirst are showing blocked queries. Watch me dive in and make the blocking go away. I keep a couple different videos of different class rotations up here to show how to use different tools to solve the same problem. Solving It…

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

We’ve got blocking! LCK% is dominating our wait stats, and tools like sp_WhoIsActive and sp_BlitzFirst are showing blocked queries. Watch me dive in and make the blocking go away. I keep a couple different videos of different class rotations up here to show how to use different tools to solve the same problem. Solving It...
To access this incredible, amazing content, you gotta get Live Class Season Pass, Mastering Index Tuning or Recorded Class Season Pass, or log in if you already shelled out the cash.
Menu