SQL Server Performance Guides
Complete, practical guides to the parts of SQL Server performance work that are the same whatever tooling you use — the DMVs, the queries, the methodology, and what to change once the evidence points somewhere.
What these are, and what they are not
Guides are about SQL Server. They contain runnable T-SQL, they assume nothing is installed, and they are useful whether or not you ever open our application. If you are looking for how a particular screen in the product works, that is the documentation; if you want a worked example of a real problem being solved end to end, that is the use cases.
How to Diagnose SQL Server Performance Problems
A repeatable method for diagnosing SQL Server performance problems: scope the symptom, triage in five minutes, then follow CPU, memory, I/O or lock evidence.
Read the guide →SQL Server Wait Statistics: The Complete Guide
A complete guide to SQL Server wait statistics — the DMVs, the queries to run, how to take a delta, what each major wait type means, and how to act on it.
Read the guide →