Skip to content

Add 14 perfmon counters to sp_PressureDetector#683

Merged
erikdarlingdata merged 1 commit intodevfrom
feature/682-perfmon-counters
Feb 24, 2026
Merged

Add 14 perfmon counters to sp_PressureDetector#683
erikdarlingdata merged 1 commit intodevfrom
feature/682-perfmon-counters

Conversation

@erikdarlingdata
Copy link
Copy Markdown
Owner

Summary

  • Adds 14 perfmon counters to the dm_os_performance_counters IN clause
  • Covers TempDB (version store, free space, temp tables), index access (full scans, index searches, page splits), and lock timeouts
  • No logic changes — existing code handles both gauge (65792) and cumulative (272696576) counter types correctly

Closes #682

Test plan

  • Deployed and tested on sql2016, sql2017, sql2019, sql2022
  • Snapshot mode (@sample_seconds = 0) — new counters appear in output
  • Delta mode (@sample_seconds = 5) — rate counters show proper differences
  • Zero-value gauge counters correctly suppressed by cntr_value > 0

🤖 Generated with Claude Code

Closes #682. Adds TempDB, index access, version store, and lock timeout
counters. Tested on sql2016-sql2022, both snapshot and delta modes.

Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>
@erikdarlingdata erikdarlingdata merged commit ac84f9b into dev Feb 24, 2026
5 checks passed
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