3.5 Lab 6: Doing the D.E.A.T.

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 /* Round 2: 39 minutes,…

To access this incredible, amazing content, you gotta get Mastering Index Tuning or Recorded Class Season Pass, 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 /* Round 2: 39 minutes,...
To access this incredible, amazing content, you gotta get Mastering Index Tuning or Recorded Class Season Pass, or log in if you already shelled out the cash.
Menu