Audit query drill-downs for missing detail columns

[erikdarlingdata]

Summary

Audit all query-related drill-down views in both Lite and Dashboard to identify columns that should be present but are missing. Some drill-downs may be showing a subset of available data while the underlying queries or data sources have additional useful columns.

Scope

• Lite: all query drill-down DataGrids (Active Queries, Top Queries, Top Procedures, Query Store, etc.)
• Dashboard: all query drill-down DataGrids
• Compare displayed columns against the underlying data source (DuckDB tables/views for Lite, SQL Server queries for Dashboard)
• Identify useful columns that are collected but not surfaced in the UI

[erikdarlingdata]

Investigation Report: Missing Drill-Down Columns

Note: This audit was run against the current schema, which is actively being modified in another session. Findings should be re-validated once collector changes are finalized.

Critical Gaps (collected but never displayed)

1. Memory Grant Stats — min_grant_kb, max_grant_kb, min_used_grant_kb, max_used_grant_kb, min_ideal_grant_kb, max_ideal_grant_kb — available in both apps' query/procedure history schemas, shown nowhere in UI
2. Thread Usage — min_reserved_threads, max_reserved_threads, min_used_threads, max_used_threads — collected, never displayed
3. CLR Time — total_clr_time in Dashboard query stats — collected, never displayed
4. SQL/Plan Handles — available in Lite QueryStatsRow model but not bound in XAML (useful for cross-tool correlation)
5. Min/Max Rows — min_rows, max_rows captured but rarely displayed

Partial Gaps

6. Spills — totals shown but delta spills missing from some history views
7. Logical Writes — only totals shown, min/max detail missing from many views
8. DOP — shown in some grids, missing from Lite procedure history entirely

Affected Areas

• History windows in both apps (QueryStatsHistory, ProcedureHistory, QueryStoreHistory)
• Main query grids in ServerTab
• Models and data service queries already have most of the data — it's the XAML bindings that are missing

Priority Suggestion

High: Memory grant columns, handle info for correlation
Medium: Min/max rows, logical write detail, thread usage
Low: Sample interval, delta spills, CLR time