Skip to content

Issue #281: Standardize memory grant stats and add charts#283

Merged
erikdarlingdata merged 1 commit intodevfrom
feature/issue-281-memory-grant-charts
Feb 25, 2026
Merged

Issue #281: Standardize memory grant stats and add charts#283
erikdarlingdata merged 1 commit intodevfrom
feature/issue-281-memory-grant-charts

Conversation

@erikdarlingdata
Copy link
Owner

Summary

  • Standardize memory grant stats collection across Dashboard and Lite
  • Add memory grant trend charts
  • Update waiting_tasks collector
  • Add delta framework for install scripts
  • Schema upgrade path for 1.3.0 to 2.0.0

Test plan

  • Verify memory grant charts render in both Dashboard and Lite
  • Verify waiting_tasks collector changes work
  • Verify delta framework install scripts run clean

🤖 Generated with Claude Code

…harts

Both apps now collect from dm_exec_query_resource_semaphores (previously Lite
used dm_exec_query_memory_grants). Added two new per-pool charts to the Memory
Grants sub-tab in both apps: Sizing (available/granted/used MB) and Activity
(grantees/waiters/timeouts/forced grants).

Dashboard: simplified collector by removing inline OUTER APPLY delta, added
memory_grant_stats to the proper delta framework (calculate_deltas), removed
unused warning columns, added upgrade script for 1.3.0-to-2.0.0.

Lite: new DuckDB schema (v14 migration), DeltaCalculator seeding for
timeout/forced counters, new Memory Grants sub-tab with two ScottPlot charts.

Also includes waiting_tasks collector simplification.

Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>
@erikdarlingdata erikdarlingdata merged commit 9cf649a into dev Feb 25, 2026
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