1.6 Lab 2: Analyzing a Running Workload

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, Live Class Season Pass PLUS Lab VM or Mastering Query Tuning, or log in if you already shelled out the cash.