Skip to content

Wait Stats: add average ms per wait view #22

@erikdarlingdata

Description

@erikdarlingdata

Context

From discussion on #12 — the current wait stats chart shows total wait time (ms), which is the right default for "where is time going?" triage. But average ms per individual wait tells a different story: "which waits are individually the slowest/most painful?"

Example: CXPACKET may dominate total time but each wait is trivial. RESOURCE_SEMAPHORE may be low total but each individual wait is brutal.

Proposal

Add either:

  • A separate "Avg Wait Time" chart alongside the existing total wait time chart
  • A toggle on the existing chart to switch between total ms and avg ms per wait

The avg-per-wait view would use the same wait type picker/checkboxes as the total time chart.

Scope

  • Dashboard
  • Lite

Raised during #12 discussion — not blocking the top-10 fix.

Metadata

Metadata

Assignees

No one assigned

    Labels

    enhancementNew feature or request

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions