Diagnose chatty applications with batch rates, cached executions, bounded session event counts, and measured round trips per user action.
Reading Performance Counters in T-SQL Without Misreading Them
Read SQL Server performance counters with two timed samples, a proper ratio base, and a concise workload and memory dashboard.
Temp Tables For Destruction: Why the Counter Stays Near Zero
The Temp Tables For Destruction counter stays flat at zero while Temp Tables Creation Rate moves, and that confuses people. This post explains what each counter counts, reads both from T-SQL, measures a creation loop, and shows that a cached temp table in a procedure moves neither counter.
Batch Requests and Compilations per Second From T-SQL
Calculate compilations per second from cumulative SQL Server counters, compare batch rates, and investigate single-use plans with context.
What are Different Methods to Know the Row Count of Table? – Interview Question of the Week #261
Question: What are Different Methods to Know the Row Count of Table? The answer to this question is very simple and many.
Read Heavy Workload or Write Heavy: Measure It in SQL Server
To tell a read heavy workload from a write heavy one, compare what the server reads with what it changes, and measure it over a window. This post counts reads and writes per table, reads the buffer and log counters with two snapshots, and explains what each lens misses.
Measure Page Splits in SQL Server With T-SQL
To measure page splits in SQL Server, read the Page Splits/sec counter twice and subtract the first reading from the second. This post loads a table with sequential keys and another with random keys, so you can see which splits are normal and which cost you. It also names the index behind the splits and shows how a lower fill factor removes most of them.