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.
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.
SQL SERVER – Presenting 4 Technology Sessions at Great Indian Developer 2014 – Contest
I am presenting four very different sessions at the Great Indian Developer Conference (GIDS) in Bangalore, April 22 to 25, 2014. Here are the details.
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.