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.
Resumable Index Rebuilds: Pausing Maintenance Without Losing Progress
Run a resumable index rebuild with ONLINE and MAX_DURATION, pause and resume it, inspect progress, and weigh edition and log costs.
Watching Live Data With the XEvent Profiler
XEvent Profiler in SSMS offers live Standard and T-SQL event views; a focused Extended Events session serves repeat investigations.
Running, Runnable, Suspended: The Life of a Query in sys.dm_exec_requests
Read running, runnable, and suspended SQL Server requests, inspect task states, and compare scheduler queues before diagnosing CPU pressure.
SQL SERVER – Performance Statistic Collection – Notes from the Field #018
Good tuning starts with good numbers. In Notes from the Field #018, David Klee explains Performance Statistic Collection and how DBAs should gather server data.
Learning SQL Wait Stats: The Complete Series Guide
Learning SQL Wait Stats is the fastest way I know to find out why a SQL Server is slow. This guide lists every post in my wait stats series, told as one story about an all-night diner, and answers the questions readers ask before they start.