3.6c Lab 6: Tuning Indexes for Specific Queries

We’ve cleaned up a lot of indexes by looking at the DMVs, and now it’s time to do the hardest part: tuning indexes on a query-by-query basis. We’ll use sp_BlitzCache to find the most resource-intensive queries, and do some targeted strike tuning. The bread crumb trail for this recording: Transact-SQL sp_BlitzIndex /* Missing index: EXEC…

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.

We’ve cleaned up a lot of indexes by looking at the DMVs, and now it’s time to do the hardest part: tuning indexes on a query-by-query basis. We’ll use sp_BlitzCache to find the most resource-intensive queries, and do some targeted strike tuning. The bread crumb trail for this recording: Transact-SQL sp_BlitzIndex /* Missing index: EXEC...
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":""}