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

    10 Recordings

    Mike is the leader of the Austin SQL User Group

Recorded At:

Recorded on:

Mar 15, 2022

More Info:

https://www.meetup.com/Austin-SQL-Server-User-Group/events/cngfgsydcfbtb/

Tags: