SQL Server 2022 Query Performance Tuning: Troubleshoot and Optimize Query Performance

© 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_23

23. A Query Tuning Methodology

Grant Fritchey¹  

(1)

Grafton, MA, USA

 

As I stated at the start of the book, query tuning can be challenging. The goal of the book is to, of course, reduce the size of that challenge. With that in mind, this final chapter is intended to act as a kind of guide around applying all the information from the rest of the book. Following the methodology laid out here will enable you to improve the performance of your SQL Server systems.

In this chapter, I’ll cover the following topics:

• Database design

• Configuration settings

• Database administration ...