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...
