Prove Your Query Tuning Works

When you tune a query, you want to be able to prove your tuning helped. We'll be going over how to prove what difference was made and how to present it, especially for presenting to others who are not at the same skill level or are in other departments. You want to highlight what changed, with numbers to prove it was a good change, along with something graphical to help illustrate the benefits. We'll go over the workflow I use to present the query tuning. The tools used are SSMS, execution plans, query statistics, screen capture, StatisticsParser, Query Store, and Word. (Not going over workload tools like distributed replay, test instances, or scripts to rerun workloads)

• Mike Burek

  13 Recordings

  Mike is the leader of the Austin SQL User Group

• Capitol Area Central Texas Users of SQL Server 85 Recordings

Mar 15, 2022

• SQL 28 Recordings
• Tuning 2 Recordings