Product has been added to your cart.

2.4 Tuning Indexes to Avoid Blocking

When your server experiences LCK% waits, it means queries are waiting on other queries to release their locks. Most of the time, you can work around this by doing index tuning. However, it’s tricky to understand whether LCK% waits mean you have too many indexes, or not enough. In this lecture, we’ll do a series…

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.

  1. Home
  3. SQL Server Training Classes by Brent Ozar
  5. Mastering Index Tuning
  7. 2.4 Tuning Indexes to Avoid Blocking
When your server experiences LCK% waits, it means queries are waiting on other queries to release their locks. Most of the time, you can work around this by doing index tuning. However, it’s tricky to understand whether LCK% waits mean you have too many indexes, or not enough. In this lecture, we’ll do a series...
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