Skip to content

Issue #281 Gap 3: Min/max extremes, Query Store gaps, collector health#294

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

Issue #281 Gap 3: Min/max extremes, Query Store gaps, collector health#294
erikdarlingdata merged 2 commits intodevfrom
feature/issue-281-memory-grant-charts

Conversation

@erikdarlingdata
Copy link
Owner

Summary

  • Surface missing min/max columns in both Dashboard and Lite query/procedure stats grids
  • Fix 11 Query Store issues: 3 broken XAML bindings + 6 hidden columns + 2 missing display helpers
  • Add consecutive failure detection to report.collection_health view (5+ recent errors = FAILING regardless of 7-day %)

Test plan

  • Both apps build clean
  • Redeployed stale procs on sql2022 (memory_grant_stats_collector, configuration_issues_analyzer, calculate_deltas)
  • Verified both collectors run without errors
  • Verified health view correctly reflects current status

Generated with Claude Code

erikdarlingdata and others added 2 commits February 25, 2026 14:22
…ore gaps, improve collector health logic

Query Stats: Add min/max physical reads, rows, grant KB, spills to Lite grids.
Add min/max physical reads to Dashboard query stats main grid.
Procedure Stats: Add min/max logical reads, physical reads, logical writes, spills to Lite grid.
Query Store: Wire 3 broken XAML bindings (ForceFailureCount, LastForceFailureReasonDesc, PlanForcingType),
add 6 hidden columns (CLR time, num physical IO reads, log bytes), add min memory/tempdb MB display.
Collector Health: Add consecutive failure detection to report.collection_health view —
5+ recent errors = FAILING, 3+ = WARNING, regardless of 7-day percentage.

Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>
…ry-grant-charts

# Conflicts:
#	Lite/Controls/ServerTab.xaml
#	Lite/Services/LocalDataService.QueryStats.cs
@erikdarlingdata erikdarlingdata merged commit 7021b7d into dev Feb 25, 2026
7 checks passed
@erikdarlingdata erikdarlingdata deleted the feature/issue-281-memory-grant-charts branch February 25, 2026 20:58
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