SQL Server 2022 Query Performance Tuning - Troubleshoot and Optimize Query Performance - Sixth Edition

Oct 18, 2026

SQL Server 2022 Query Performance Tuning: Troubleshoot and Optimize Query Performance, Sixth Edition by Grant Fritchey, focuses on identifying and correcting performance problems in SQL Server queries. The book outlines a structured tuning process, explains what “good enough” performance means, and helps establish comparison points for evaluating changes. It covers common and likely issues such as poor indexing, missing or inaccurate statistics, problematic T-SQL, execution plan problems, excessive blocking, deadlocks, and non-set-based operations.

LanguageEnglish

CategoryTechnology

FormatPDF

Pages731

Reading Time30 h 42 min

AccessFree to download

About the Author

About the Technical Reviewer

Acknowledgments

Introduction

Chapter 1: Query Performance Tuning

The Query Performance Tuning Process

Performance Issues

A Repetitive Process

Understanding What Defines “Good Enough”

Establishing Comparison Points

Most Likely Performance Issues

Common Performance Issues

Insufficient or Poor Indexes

Inaccurate or Missing Statistics

Bad T-SQL

Problematic Execution Plans

Excessive Blocking

Deadlocks

Non-Set-Based Operations

Incorrect Database Design

Poor Execution Plan Reuse

SQL Server 2022 Query Performance Tuning Troubleshoot and Optimize Query Performance Sixth Edition Grant Fritchey SQL Server 2022 Query Performance Tuning: Troubleshoot and Optimize Query Performance Grant Fritchey Grafton, MA, USA ISBN-13 (pbk): 978-1-4842-8890-0 ISBN-13 (electronic): 978-1-4842-8891-7 [https://doi.org/10.1007/978-1-4842-8891-7](https://doi.org/10.1007/978-1-4842-8891-7) Copyright © 2022 by Grant Fritchey This work is subject to copyright. All rights are reserved by the Publisher, whether the whole or part of the material is concerned, specifically the rights of translation, reprinting, reuse of illustrations, recitation, broadcasting, reproduction on microfilms or in any other physical way, and transmission or information storage and retrieval, electronic adaptation, computer software, or by similar or dissimilar methodology now known or hereafter developed. Trademarked names, logos, and images may appear in this book. Rather than use a trademark symbol with every occurrence of a trademarked name, logo, or image we use the names, logos, and images only in an editorial fashion and to the benefit of the trademark owner, with no intention of infringement of the trademark. The use in this publication of trade names, trademarks, service marks, and similar terms, even if they are not identified as such, is not to be taken as an expression of opinion as to whether or not they are subject to proprietary rights. While the advice and information in this book are believed to be true and accurate at the date of publication, neither the authors nor the editors nor the publisher can accept any legal responsibility for any errors oromissions that maybe made. The publisher makes no warranty, express or implied, with respect to the material contained herein. Managing Director, Apress Media LLC: Welmoed Spahr Acquisitions Editor: Jonathan Gennick Development Editor: Laura Berendson Coordinating Editor: Jill Balzano Cover Photo by Lucas Kapla on Unsplash Distributed to the book trade worldwide by Springer Science+Business Media LLC, 1 New York Plaza, Suite 4600, New York, NY 10004. Phone 1-800-SPRINGER, fax (201) 348-4505, e-mail orders-ny@springer-sbm. com, or visit www.springeronline.com. Apress Media, LLC is a California LLC and the sole member (owner) is Springer Science + Business Media Finance Inc (SSBM Finance Inc) . SSBM Finance Inc is a Delaware corporation. For information on translations, [please e-mail booktranslations@springernature.com](please e-mail booktranslations@springernature.com); for reprint, paperback, or audio rights, [please e-mail bookpermissions@springernature.com](please e-mail bookpermissions@springernature.com). Apress titles may be purchased in bulk for academic, corporate, or promotional use. eBook versions and licenses are also available for most titles. For more information, reference our Print and eBook Bulk Sales web page at [http://www.apress.com/bulk-sales](http://www.apress.com/bulk-sales). Any source code or other supplementary material referenced by the author in this book is available to readers on GitHub. For more detailed information, please visit [http://www.apress.com/source-code](http://www.apress.com/source-code). Printed on acid-free paper To my family. Table of Contents About the Author 􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮 xix About the Technical Reviewer 􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮 xxi Acknowledgments 􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮 xxiii Introduction 􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮 xxv Chapter 1: Query Performance Tuning 􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮 1 The Query Performance Tuning Process 􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮􀀮

FAQs

What tuning workflow does the book emphasize for SQL Server queries?

It presents a repeatable query performance tuning process, including establishing comparison points and iterating based on observed performance outcomes.

Which categories of performance problems are discussed in Chapter 1?

The chapter covers issues such as insufficient or poor indexes, inaccurate or missing statistics, bad T-SQL, problematic execution plans, excessive blocking, deadlocks, and non-set-based operations.

How does the book help decide whether query performance is “good enough”?

It explains how “good enough” is defined and uses comparison points to evaluate the impact of tuning changes against practical targets.

Oct 18, 2026

Upload by Pentious