2.3b Lab 3: Adding Indexes with Clippy and the DMVs – Brent Does It

In this lab, we start from zero – we drop all indexes first, and then use SQLQueryStress to run our real-life workload simulation. However, in this lab, you’re not allowed to look at the plan cache DMVs in order to do your index tuning. Use sp_BlitzIndex to get Clippy’s recommendations, and then re-imagine them now…

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.

In this lab, we start from zero – we drop all indexes first, and then use SQLQueryStress to run our real-life workload simulation. However, in this lab, you’re not allowed to look at the plan cache DMVs in order to do your index tuning. Use sp_BlitzIndex to get Clippy’s recommendations, and then re-imagine them now...
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":""}