Jump to ratings and reviews
Rate this book

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

Rate this book
A new era of SQL Server is here, and this latest edition of Grant Fritchey’s best-selling dive into SQL Server query performance can ensure your queries keep up.


The fundamentals are still You’ll learn how statistics and indexes impact performance, how to identify poorly performing queries, and how to discover effective solutions. But this new edition also includes advanced features unique to SQL Server 2025, such as AI integration for automatic tuning, insights on using extended events, automatic execution plan correction, and more. It’s a must-have resource designed to empower you to troubleshoot slow-performing queries and make them run faster than ever.


The book is a treasure trove of instruction, insight, and advice. As you dive in, you’ll encounter key fundamentals, from statistics and data distribution to cardinality and parameter sniffing, and learn to analyze and design your indexes and queries using best practices that prevent performance problems before they occur. You’ll also explore advanced features like Query Store for managing and controlling execution plans, automated performance tuning, and memory-optimized OLTP tables and procedures—and learn how SQL Server 2025 makes it all more powerful and automatable than ever.


What You Will Learn



Use Query Store to understand and easily change query performance
Recognize and eliminate bottlenecks leading to slow performance
Tune queries whether on-premises, in containers, or on cloud platform providers
Implement best practices in T-SQL to minimize performance risk
Design in the performance that you need through careful query and index design
Understand how built-in, automatic tuning can assist your performance enhancement efforts
Protect query performance during upgrades to the newer versions of SQL Server

Who This Book Is For


Developers and database administrators with responsibility for query performance in SQL Server environments, and anyone responsible for writing or creating T-SQL queries and in need of insight into bottlenecks—including how to identify them, understand them, and eliminate them

783 pages, Paperback

Published February 1, 2026

Loading...
Loading...

About the author

Grant Fritchey

31 books13 followers
I have over thirty years experience working in technical support, development and database administration. I'm work for Redgate Software as a Product Advocate. I am a Microsoft Data Platform MVP and AWS Community Builder. I write articles for publication at SQL Server Central and Simple-Talk. I present sessions at events, large and small, all around the world and online. I work with both SQL Server and PostgreSQL and have authored multiple books on a variety of topics related to databases and data management.

Ratings & Reviews

What do you think?
Rate this book

Friends & Following

Create a free account to discover what your friends think of this book!

Community Reviews

5 stars
1 (100%)
4 stars
0 (0%)
3 stars
0 (0%)
2 stars
0 (0%)
1 star
0 (0%)
Displaying 1 - 1 of 1 review
Profile Image for John Deardurff.
366 reviews5 followers
February 4, 2026
As the technical reviewer for SQL Server 2025 Query Performance Tuning, I had the privilege of diving deeply into this book long before publication; and I can confidently say it is one of the most comprehensive, practical, and forward‑looking SQL Server performance tuning guides available today.

What truly sets this book apart is its blend of real‑world clarity and deep technical insight. Grant does a fantastic job translating complex internals; query processing enhancements, cardinality estimation improvements, TempDB changes, Intelligent Query Processing upgrades, and new 2025‑specific engine behaviors, into explanations and guidance that SQL Server professionals can apply immediately.

The examples are relevant, the walkthroughs are detailed without being overwhelming, and the performance tuning techniques reflect how modern SQL Server workloads actually behave. Whether you're working on‑prem, in Azure, or in a hybrid environment, this book helps you understand not just what changed in SQL Server 2025, but why those changes matter for performance.

Even as someone who lives and breathes SQL Server, I learned a bit during the review process. This will be a go‑to reference for DBAs, developers, architects, and anyone looking to get the most out of SQL Server 2025.
Displaying 1 - 1 of 1 review