Log free space per volume from SQL Server volume metadata, keep one daily sample per mount point, and compare change with LAG.
Visible Offline Schedulers: Find CPUs SQL Server Ignores
Visible offline schedulers are CPUs that Windows shows and SQL Server refuses to use. This post reads the scheduler status with tested queries, compares it with the CPU count and affinity, and explains the two common causes. It also shows the statement that returns the CPUs to automatic affinity.
Activity Monitor Keeps Freezing: Fix WMI and Permissions
When Activity Monitor keeps freezing, the cause can be a missing SQL permission or a missing WMI permission for the Windows account. This post tests the SQL side on SQL Server 2025, walks through the WMI security fix and explains what CIMV2 means. It also gives a query that reads the same activity without Activity Monitor.
Query for CPU Pressure: Sample the Scheduler Queue
To sample the scheduler queue, read the runnable counts of every scheduler eight times, one second apart, and compare the result with a baseline. This post shows the queue on a quiet server and again while more busy sessions than schedulers run. It reads the spread, the streak and the average that tell pressure from noise.
Capturing sp_WhoIsActive Snapshots to a Table Every Minute
Capture sp_WhoIsActive snapshots every minute, keep seven days, and query past blockers and long requests from a logging table.
Lightweight Query Profiling: Live Progress Without the Old Overhead
Use lightweight query profiling to inspect live operator rows and in-flight plans, while avoiding misleading progress percentages.
Performance Condition Alerts: Warnings Before a Log File Fills
Build performance condition alerts for log usage, tempdb free space, and blocking, with sensible delays and an operator response.







