Skip to content

Exclude WAITFOR queries from top queries views#14

Merged
erikdarlingdata merged 1 commit intodevfrom
feature/4-exclude-waitfor
Feb 13, 2026
Merged

Exclude WAITFOR queries from top queries views#14
erikdarlingdata merged 1 commit intodevfrom
feature/4-exclude-waitfor

Conversation

@erikdarlingdata
Copy link
Owner

Summary

  • Filter out WAITFOR-based queries from all top queries display views
  • Applies to both Dashboard (query stats + Query Store) and Lite (query stats + Query Store)
  • Data stays in the database — only filtered at read/display time

Closes #4

Test plan

  • Dashboard builds clean (0 warnings, 0 errors)
  • Lite builds clean (0 warnings, 0 errors)
  • Dashboard top queries no longer show WAITFOR entries
  • Lite top queries and Query Store no longer show WAITFOR entries

🤖 Generated with Claude Code

WAITFOR-based queries (e.g., Service Broker queue listeners) dominate
duration rankings but aren't actionable. Filter them at the display
layer in both Dashboard and Lite query stats + Query Store queries.

Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>
@erikdarlingdata erikdarlingdata merged commit 67a2c39 into dev Feb 13, 2026
@sandimschuh
Copy link

Im on the Lite version. There the "Top Queries by Duration" tab now shows no data at all. Where as "Active Queries" still is bloated with my thousands of WAITFOR queries (BROKER_RECEIVE_WAITFOR).

@erikdarlingdata
Copy link
Owner Author

@sandimschuh

  1. Yeah, I missed the active queries tabs. I'll get that fixed.
  2. I'm showing regular data flow in the other query tabs,

erikdarlingdata added a commit that referenced this pull request Feb 13, 2026
Apply consistent blue-gray tinted color palette across both Dashboard and Lite:
- Backgrounds: #111217, #181b1f, #22252b, #2a2d35 (Grafana-style)
- Text: #E4E6EB (primary), #9DA5B4 (dim), #6B7280 (muted)
- Borders: #2a2d35 / #33363e
- Chart backgrounds, grid lines, axis text, legends updated to match
- Calendar pickers styled consistently

Fix system tray visual issues in both apps:
- Replace native ToolTipText (Windows light theme) with custom dark TrayToolTip
- Add full ContextMenu ControlTemplate to eliminate WPF default light gutter
- Add emoji icons to Lite tray context menu (matching Dashboard)
- Transparent backgrounds on all tray menu emoji icons

Also includes WAITFOR exclusion filters from #14 in query snapshots.

Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>
@erikdarlingdata erikdarlingdata deleted the feature/4-exclude-waitfor branch February 13, 2026 17:24
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.

2 participants