1.6 Lab 2: Analyzing a Running Workload (63m)

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.

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.
Menu
{"cart_token":"","hash":"","cart_data":""}