© 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 Fritchey1  
(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 ...

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.

Start your free trial