Skip to content

Add memory summary cards to Memory Overview#181

Merged
erikdarlingdata merged 1 commit intodevfrom
feature/memory-summary-cards
Feb 20, 2026
Merged

Add memory summary cards to Memory Overview#181
erikdarlingdata merged 1 commit intodevfrom
feature/memory-summary-cards

Conversation

@erikdarlingdata
Copy link
Owner

Summary

  • Adds total_physical_memory_mb and committed_target_memory_mb columns to collect.memory_stats table
  • Collector now pulls from sys.dm_os_sys_info (committed target) and adds total physical from sys.dm_os_sys_memory
  • Memory Overview summary panel shows absolute GB values: Physical Memory, SQL Server Memory, Target Memory
  • Buffer Pool and Plan Cache now show GB alongside percentage (e.g., "21.4 GB (83.2%)")
  • Includes ALTER TABLE migration for existing installs (NULLable columns)

Closes #140

Test plan

  • Re-run install scripts (02_create_tables.sql, 06_ensure_collection_table.sql, 14_collect_memory_stats.sql) on test server
  • Verify new columns exist in collect.memory_stats after install
  • Wait for 1-2 collection cycles and verify total_physical_memory_mb and committed_target_memory_mb are populated
  • Verify Memory Overview summary panel shows Physical Memory, SQL Server Memory, Target Memory in GB
  • Verify Buffer Pool and Plan Cache show GB values with percentages
  • Verify summary gracefully shows "N/A" for rows collected before the schema change

Generated with Claude Code

…iew (#140)

Adds total_physical_memory_mb and committed_target_memory_mb columns to
collect.memory_stats table, collected from sys.dm_os_sys_memory and
sys.dm_os_sys_info. Memory Overview summary panel now shows absolute GB
values for Physical Memory, SQL Server Memory, Target Memory, Buffer Pool,
and Plan Cache alongside percentages. Includes ALTER TABLE migration for
existing installs.

Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>
@erikdarlingdata erikdarlingdata merged commit 62cd3f2 into dev Feb 20, 2026
7 checks passed
@erikdarlingdata erikdarlingdata deleted the feature/memory-summary-cards branch February 20, 2026 00:43
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