Skip to content

Issue #280: Add Current Waits charts to Blocking tab#286

Merged
erikdarlingdata merged 1 commit intodevfrom
worktree-issue-280-current-waits
Feb 25, 2026
Merged

Issue #280: Add Current Waits charts to Blocking tab#286
erikdarlingdata merged 1 commit intodevfrom
worktree-issue-280-current-waits

Conversation

@erikdarlingdata
Copy link
Owner

Summary

  • Adds a new Current Waits tab to the Blocking section in both Dashboard and Lite, positioned next to the existing Blocking/Deadlock Trends tab
  • Two charts per app: Wait Duration by Wait Type (multi-series line, total wait_duration_ms per wait type over time) and Blocked Sessions by Database (multi-series line, count of sessions with blocking_session_id > 0 per database over time)
  • Uses raw point-in-time wait_duration_ms values — no delta calculation needed since waiting_tasks snapshots the current wait state, not cumulative counters
  • Aligns Lite collector with the SQL Server collector trimmed in Data audit: collected but not displayed gaps #281 — stops collecting resource_description (now NULL)

Test plan

  • Connect both apps to a server with active blocking
  • Verify Current Waits tab appears second in tab order (after Trends/Blocking/Deadlock Trends)
  • Wait ~1 min for collection, verify wait duration chart shows lines per wait type
  • Verify blocked sessions chart shows lines per database when blocking is present
  • Verify empty state (flat zero line / no data message) when no waiting tasks collected
  • No regressions on existing Blocking/Deadlock Trends, Blocking, Deadlocks tabs

🤖 Generated with Claude Code

… Lite

Both apps now have a "Current Waits" tab next to the Blocking/Deadlock Trends
tab, showing two charts from collected waiting_tasks data:
- Wait Duration by Wait Type: multi-series line chart of total wait_duration_ms
  per wait type over time (raw point-in-time values, not deltas)
- Blocked Sessions by Database: multi-series line chart of session count with
  blocking_session_id > 0 per database over time

Also aligns Lite collector with SQL Server collector from issue #281 — stops
collecting resource_description (now passed as NULL to match the trimmed-down
SQL Server collector which only populates session_id, wait_type,
wait_duration_ms, blocking_session_id, and database_name).

Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
@erikdarlingdata erikdarlingdata merged commit 9b9161f into dev Feb 25, 2026
3 checks passed
@erikdarlingdata erikdarlingdata deleted the worktree-issue-280-current-waits 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