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, Live Class Season Pass PLUS Lab VM or Mastering Index Tuning, or log in if you already shelled out the cash.

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, Live Class Season Pass PLUS Lab VM or Mastering Index Tuning, or log in if you already shelled out the cash.
Menu
{"cart_token":"","hash":"","cart_data":""}