Themed perfmon counter packs + new counters #255
Description
Summary
Add themed perfmon counter pack selector to Lite and Dashboard perfmon tabs, letting users filter counters by problem area instead of scrolling through the full list.
New Counters to Collect (14)
All 65792 or 272696576 cntr_type (no fraction types):
| Counter | cntr_type |
|---|---|
| Free list stalls/sec | 272696576 |
| Full Scans/sec | 272696576 |
| Index Searches/sec | 272696576 |
| Page Splits/sec | 272696576 |
| Workfiles Created/sec | 272696576 |
| Worktables Created/sec | 272696576 |
| Temp Tables Creation Rate | 272696576 |
| Version Generation rate (KB/s) | 272696576 |
| Version Cleanup rate (KB/s) | 272696576 |
| Lock Timeouts/sec | 272696576 |
| Version Store Size (KB) | 65792 |
| Free Space in tempdb (KB) | 65792 |
| Active Temp Tables | 65792 |
| Processes blocked | 65792 |
Themed Packs
Memory Pressure: Memory Grants Pending, Granted Workspace Memory (KB), Target Server Memory (KB), Total Server Memory (KB), Stolen Server Memory (KB), Lock Memory (KB), SQL Cache Memory (KB), Lazy writes/sec, Free list stalls/sec, Reduced memory grants/sec, Memory grant queue waits, Thread-safe memory objects waits, Page reads/sec, Readahead pages/sec
CPU / Compilation: Batch Requests/sec, SQL Compilations/sec, SQL Re-Compilations/sec, Query optimizations/sec, Active parallel threads, Active requests, Queued requests, Wait for the worker
I/O Pressure: Page reads/sec, Page writes/sec, Checkpoint pages/sec, Page lookups/sec, Readahead pages/sec, Background writer pages/sec, Log Flushes/sec, Log Bytes Flushed/sec, Log Flush Write Time (ms), Page IO latch waits, Log buffer waits, Log write waits, Full Scans/sec, Index Searches/sec, Page Splits/sec
TempDB Pressure: Version Store Size (KB), Free Space in tempdb (KB), Active Temp Tables, Version Generation rate (KB/s), Version Cleanup rate (KB/s), Temp Tables Creation Rate, Workfiles Created/sec, Worktables Created/sec, Forwarded Records/sec
Lock / Blocking: Lock Requests/sec, Lock Wait Time (ms), Lock Waits/sec, Number of Deadlocks/sec, Table Lock Escalations/sec, Blocked tasks, Lock waits, Non-Page latch waits, Page latch waits, Processes blocked, Lock Timeouts/sec
General Throughput: Batch Requests/sec, SQL Compilations/sec, SQL Re-Compilations/sec, Query optimizations/sec, Network IO waits
All Counters (default): Everything, like today
Notes
- Some counters appear in multiple packs where they tell the story (e.g., Page reads/sec in both Memory and I/O)
- Memory Pressure pack includes I/O counters to show downstream impact of buffer pool churn
- Transactions/sec excluded (just measures modifications, redundant with Batch Requests)
- Requests completed/sec excluded (Resource Governor counter, not useful without RG configured)
- Skip 537003264 (fraction) counter types — Buffer cache hit ratio etc. require different calculation logic