Resource bottlenecks hide in the wait statistics, under a pile of idle waits and totals since startup. This post builds a script that removes the idle waits, measures an interval and groups the rest by resource. It also explains how to read each group and the signal wait.
Deleting Millions of Rows in Batches Without Filling the Log
Plan deleting millions of rows with bounded commits, an indexed cutoff, log reuse checks, and a clear choice of retention method.
Detect Performance Problems in SQL Server With DMVs
To detect performance problems in SQL Server, start with four suspects and a few dynamic management views that show CPU waits, memory use and the system_health session. This guest post by Eduardo Castro explains where to look first.
Parameter Sensitive Plans: Reading Query Variants in Query Store
Inspect query variants and dispatcher plans in Query Store, compare skewed parameter values, and read the boundaries selecting each plan.
SQL SERVER – Identifying If Database Supports InMemory OLTP Functionality
I had recently received an email about InMemory OLTP Functionality in Email when I was having a vacation with my family in the Australia.







