Diagnose cube performance by comparing the same MDX query, processing changes and resource pressure before choosing a repair.
PAGEIOLATCH_SH Waits: Slow Storage or Too Many Reads
Diagnose PAGEIOLATCH_SH waits by comparing file read latency with Query Store physical reads before blaming storage or changing indexes.
Finding the Slowest Stored Procedures With sys.dm_exec_procedure_stats
Find the slowest stored procedures with cache statistics, compare CPU and reads, and use two snapshots to isolate one busy hour.
OFFSET FETCH Paging and Its Deep Page Problem
Use OFFSET FETCH with a unique sort order, compare early and deep page reads, and decide when a cursor based approach fits better.
DMV Snapshot Deltas for a Query Activity Interval
DMV snapshot deltas show counter growth for cached statements that survive two observations. Compare their identities and report missing coverage before ranking activity.
Statistics Histograms Explained
Statistics histograms explained through steps, RANGE_ROWS, EQ_ROWS, and DBCC SHOW_STATISTICS help connect data shape to plan estimates.
Wait Stats Summary: Every Wait on One Page
This wait stats summary puts every wait from the series on one page: what it means and the first fix to try. On Night 28 at the Clipboard Diner, the critic finally comes on an ordinary Tuesday. The lesson of the whole series is the same as the story’s: know what normal looks like on your server.