We ran another load test, and we’re up to 80 queries per minute. We take one last pass through the plan cache – not that there’s not more room for improvement, because there certainly is, but we’re just limited in terms of how much time we have in the day. This time, the top query…
4.3f Lab 6: usp_Q6627, Take 2 (34m)
We ran another load test, and we’re up to 80 queries per minute. We take one last pass through the plan cache – not that there’s not more room for improvement, because there certainly is, but we’re just limited in terms of how much time we have in the day. This time, the top query...
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.
- 0.1 Prerequisites Before the Class (59 min)
- 0.2 How to Set Up Your Own Lab Server
- 0.4 The BE CREEPY Method (14m)
- 1.1 How SQL Server Builds Query Plans
- 1.2 Cardinality Estimation
- 1.3 CTEs, Temp Tables, and APPLY
- 1.4 Lab 1: Improving Estimates
- 1.5 Using sp_BlitzCache to Find the Right (Wrong) Queries
- 1.6 Lab 2: Analyzing a Running Workload
- 2.1 Tuning for SELECT * and Lots of Rows
- 2.2 User-Defined Functions
- 2.3 Lab 3: Changing Results and Parameters
- 2.4 Dynamic SQL Pro Tips
- 2.5 Lab 4: Advanced Rewrites
- 3.1 Parameter Sniffing
- 3.2 Lab 5: Parameter Sniffing
- 3.3 Avoiding Deadlocks
- 3.4 SQL Server 2017 & 2019’s New Robots
- 4.1 Lab 6: The Final Setup
- 4.2 Lab 6: Index Tuning (33m)
- 4.3a Lab 6: usp_Q6627 (29m)
- 4.3b Lab 6: Logging sp_BlitzCache to a Table (5m)
- 4.3c Lab 6: usp_Q7521 (25m)
- 4.3d Lab 6: usp_Report3 (15m)
- 4.3e Lab 6: usp_FindRelatedPosts (24m)