Something just conversation which I keep on doing again for ages. One of the conversations which never gets old is Table Partitioning for Slow Performance.
CPU Scheduler Waiting on Disk: Read Pending Disk IO
A CPU scheduler waiting on disk shows pending disk IO on its scheduler. This post reads sys.dm_os_schedulers once and in a short sampling loop, then confirms the result with file latency.
SQL SERVER – Troubleshooting High CPU
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.