Virtual - Prove Your Query Tuning Works - Mike Burek

Topic: Prove Your Query Tuning Works

Speaker: Mike Burek

Virtual - Link is available when you click "Attend" for the meeting.

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)