Skip to content

Add missing perfmon counters to SQL collector, fix TempDB Pressure pack#301

Merged
erikdarlingdata merged 1 commit intodevfrom
fix/perfmon-missing-counters
Feb 26, 2026
Merged

Add missing perfmon counters to SQL collector, fix TempDB Pressure pack#301
erikdarlingdata merged 1 commit intodevfrom
fix/perfmon-missing-counters

Conversation

@erikdarlingdata
Copy link
Owner

Summary

  • SQL collector was missing 14 counters that sp_PressureDetector collects and the UI packs reference
  • TempDB Pressure pack showed only "Forwarded Records/sec" (not a tempdb counter) because the 8 real tempdb counters were never collected
  • Also missing from I/O and Lock packs: Full Scans/sec, Index Searches/sec, Page Splits/sec, Free list stalls/sec, Processes blocked, Lock Timeouts/sec
  • Removed "Forwarded Records/sec" from TempDB Pressure pack in both apps
  • SQL collector now matches sp_PressureDetector's counter list exactly

Test plan

  • All 14 new counter names verified in sys.dm_os_performance_counters on sql2022
  • Collector deployed and run — all counters collecting
  • Dashboard and Lite build successfully

🤖 Generated with Claude Code

SQL collector was missing 14 counters that sp_PressureDetector collects
and the UI packs reference. TempDB Pressure pack only showed Forwarded
Records/sec (which isn't even a tempdb counter) because the 8 actual
tempdb counters were never collected. Also missing: Full Scans/sec,
Index Searches/sec, Page Splits/sec, Free list stalls/sec, Processes
blocked, Lock Timeouts/sec.

Remove Forwarded Records/sec from TempDB Pressure pack in both apps.

Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>
@erikdarlingdata erikdarlingdata merged commit 2485799 into dev Feb 26, 2026
7 checks passed
@erikdarlingdata erikdarlingdata deleted the fix/perfmon-missing-counters branch February 27, 2026 23:01
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

1 participant