Prove Your Query Tuning Works
Abstract:
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)
Speakers:
-
Mike Burek
13 RecordingsMike is the leader of the Austin SQL User Group
Recorded At:
- Capitol Area Central Texas Users of SQL Server 85 Recordings
Recorded on:
Mar 15, 2022