A slow SQL Server needs a quick look before any deep tuning. Three queries, using only what SQL Server ships, show what is running, which session sits at the head of a blocking chain and what the server is waiting on. Every result here comes from a slowdown staged on SQL Server 2025.
Memory-Optimized Table Variables
Memory-optimized table variables can avoid tempdb work, but they need a filegroup, indexed table type, memory budget, and workload tests.
Index Usage Stats Reset: Reading Them Without Being Fooled
Use index usage stats reset in SQL Server with practical examples, clear checks, and the limits you need before changing your database.
Unstable Queries: Finding Wide Duration Swings in Query Store
Find unstable queries with Query Store duration spread, weight averages, and separate plan changes from waits and parameter effects.
Signal Waits: Telling CPU Pressure From Slow Disks
Measure signal waits over an interval, compare scheduler queues and file latency, and separate CPU scheduling pressure from storage delays.
When In-Memory OLTP Helps and When It Does Not
Learn when In-Memory OLTP can reduce transaction contention, which limitations still matter, and what to measure before changing tables.
What the Cardinality Estimator Does and When It Is Wrong
Understand how the cardinality estimator predicts rows, why estimates go wrong, and which statistics and plan checks help you investigate.







