© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2022
G. FritcheySQL Server 2022 Query Performance Tuninghttps://doi.org/10.1007/978-1-4842-8891-7_3

3. Methods for Capturing Query Performance Metrics

Grant Fritchey1  
Grafton, MA, USA

In order to understand which queries we should be focused on for query tuning, we need a method to accurately measure query performance. Also, as we make various attempts to improve query performance, we need to be able to capture the metrics that will enable us to understand how well our improvements are working, or if they are working. Finally, we need to be able to measure the results of our improvements in order to both validate that they worked and also start the process ...

Get SQL Server 2022 Query Performance Tuning: Troubleshoot and Optimize Query Performance now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.