We are going to discuss Troubleshooting High CPU in SQL Server. This is why many hire me for Comprehensive Database Performance Health Check.
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.
Aggregate Pushdown: Letting the Columnstore Scan Do the Summing
Verify aggregate pushdown in columnstore scans, inspect locally aggregated rows, and compare numeric aggregates with expressions.
SQL SERVER – Rebuilding Index with Compression
To rebuild an Index with Compression, I target its own settings and partitions. Customer ROW and PAGE results need separate evaluation.
Trigger Blocks Index Maintenance: How to Let Rebuilds Pass
A trigger blocks index maintenance when it guards every index event, because a rebuild is an index event too. This post shows the failure, then a trigger that reads EVENTDATA and lets rebuilds through while it still blocks create, drop and disable.
Index a Computed Column in SQL Server
To index a computed column, define the formula once on the table and create a normal index on it. This post loads 200,000 rows, shows the scan, then the seek after the index, and tests the rules that decide whether SQL Server accepts the column.
SQL SERVER – High Frequency Cached Query Counts and Statement Metrics
I measure High Frequency cached statements with decimal executions-per-second arithmetic. A customer wanted to identify the busiest queries.







