A query that took one second last month now takes thirty. Users are complaining, and you’re staring at an execution plan full of operators you don’t recognise. Sound familiar?
Performance tuning is the skill that separates people who write SQL from people who understand databases. These five books will teach you how indexes work, how to read execution plans and how to find the real cause of a slow query. Two of them are even free.
Disclosure: some links on this page are affiliate links. If you buy through them, SimplifyDatabase may earn a small commission at no extra cost to you. It helps keep the site free.
Quick Comparison
| Book | Database | Best for | Price |
|---|---|---|---|
| SQL Performance Explained | All major databases | Understanding indexes properly | Paid (free web version) |
| SQL Server Execution Plans (3rd Edition) | SQL Server | Reading execution plans | Free ebook |
| SQL Server 2022 Query Performance Tuning | SQL Server | A complete tuning method | Paid |
| Expert Performance Indexing in SQL Server 2019 | SQL Server | Designing the right indexes | Paid |
| Troubleshooting SQL Server | SQL Server | Fixing a server under pressure | Free ebook |
1. SQL Performance Explained
Author: Markus Winand
If you read only one performance book, read this one. It’s short (around 200 pages) and focuses on the thing that matters most: indexes. Winand explains how a B-tree index really works, why the order of columns in an index matters, why functions on columns stop an index from being used, and how joins, sorting and pagination interact with indexes.
It covers Oracle, SQL Server, MySQL and PostgreSQL side by side. The same content is also available free on his website, Use The Index, Luke.
Why I recommend it: It turns indexing from guesswork into something you can reason about.
Keep in mind: it’s about indexes and query design, not server settings or hardware.
2. SQL Server Execution Plans (3rd Edition)
Author: Grant Fritchey (Redgate)
The execution plan is SQL Server’s explanation of how it ran your query. This book teaches you to read it: every common operator, what estimated vs actual rows mean, how to spot scans, key lookups, sorts and spills, and how plans are cached and reused.
Redgate offers it as a free ebook, which makes it an easy decision.
Why I recommend it: You can’t tune what you can’t see. This book makes plans readable.
Keep in mind: it explains plans rather than giving you a full tuning process. Pair it with the next book.
3. SQL Server 2022 Query Performance Tuning
Author: Grant Fritchey (Apress)
Now in its sixth edition, this is the most complete SQL Server tuning book available. It covers measuring performance, Query Store, statistics, index design, parameter sniffing, blocking, deadlocks, memory-optimised tables and the newer Intelligent Query Processing features.
Why I recommend it: It gives you a repeatable method, not just tips, from finding the slowest queries to proving that your fix worked.
Keep in mind: it’s a big book. Use it as a reference, chapter by chapter, when you meet each problem.
4. Expert Performance Indexing in SQL Server 2019
Author: Jason Strate (Apress)
This book goes deep on one subject: indexes in SQL Server. Clustered vs nonclustered, included columns, filtered indexes, columnstore, index maintenance, and how to use the missing index DMVs without blindly creating everything they suggest.
Why I recommend it: Most performance problems are indexing problems. This book helps you design indexes on purpose instead of adding them one complaint at a time.
Keep in mind: read SQL Performance Explained first for the general theory.
5. Troubleshooting SQL Server: A Guide for the Accidental DBA
Authors: Jonathan Kehayias and Ted Krueger (Redgate)
Sometimes the problem isn’t one query, it’s the whole server. This book walks through the most common causes of a struggling SQL Server: high CPU, memory pressure, disk I/O bottlenecks, blocking, and a full transaction log. It shows how to diagnose each one with wait statistics and DMVs. It’s also a free ebook from Redgate.
Why I recommend it: It’s practical and calm, perfect for developers who suddenly become responsible for the database.
Keep in mind: it’s an older book, so some screenshots and versions are dated. The diagnostic approach is still valid.
Where to Start
- Never thought about indexes before? SQL Performance Explained.
- Using SQL Server and confused by plans? Grab the free Execution Plans ebook.
- Want a full process? SQL Server 2022 Query Performance Tuning.
- The whole server is slow, not one query? Troubleshooting SQL Server.
Frequently Asked Questions
Which performance tuning book should I read first?
Start with SQL Performance Explained. It teaches how indexes work, and that is the root of most slow queries in every database. If you use SQL Server, download the free SQL Server Execution Plans ebook next, so you can see what the server is actually doing.
Are these books useful for MySQL or PostgreSQL?
SQL Performance Explained is: it covers MySQL, PostgreSQL, SQL Server and Oracle side by side. The other four books are SQL Server only. For MySQL, High Performance MySQL (O’Reilly) is the classic next step.
Do I need a book, or are free articles enough?
Free articles are enough to fix a specific problem. A book gives you a complete method, so you know what to check first and why. The two free Redgate ebooks are a good middle ground: book-length and structured, at no cost.
Are the older books still worth reading?
Yes. Troubleshooting SQL Server was published in 2011 and the Execution Plans 3rd edition in 2018, so some screenshots and version details are dated. The way they teach you to diagnose problems (wait statistics, DMVs, reading plans) still applies to current versions. For the newest features, such as Query Store and Intelligent Query Processing, use SQL Server 2022 Query Performance Tuning.
Free Guides to Read Alongside
These books pair well with our own performance series, which uses real-world examples:
- SQL Server performance troubleshooting: a step-by-step guide
- How to read a SQL Server execution plan
- Index seek vs index scan
- Missing indexes in SQL Server
- Eager index spool: what it means and how to fix it
- SQL Server parameter sniffing: why a query is fast in SSMS but slow in the app
Looking for more? See the best SQL Server books or browse in-depth book reviews under the SQL Books menu.