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, The Team Membership, Mastering Index Tuning, Level 3 Bundle (Live Classes, Lab VM Included) or Level 2 Bundle (Live Classes, No VM Included), or log in if you already shelled out the cash.