Things start to get harder because we’re not going to tell you which queries to tune. You’ll start a load test with SQLQueryStress, then after a few minutes, you’ll start analyzing the plan cache with sp_BlitzCache. You’ll pick the most resource-intensive queries to tune, and then tune them as quickly as possible. Part 1: Lab...
To access this incredible, amazing content, you gotta get Live Class Season Pass, The Team Membership, Mastering Query 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.