Skip to content

Enrich alert emails with query context #45

@erikdarlingdata

Description

@erikdarlingdata

Migrated from erikdarlingdata/Monitor#29

Current Behavior

Alert emails are missing useful query context:

Deadlock alerts

  • Currently: Only includes victim query text
  • Needed: Include winner/survivor query text too — knowing what killed you is only half the story

High CPU alerts

  • Currently: Just reports the CPU percentage
  • Needed: Include top 3 CPU-consuming queries at time of alert

Memory alerts

  • TBD: Investigate what the current memory alert triggers on and whether memory grant information (query text, requested/granted memory) should be included

Expected Behavior

Each alert email should contain enough context that a DBA can start investigating without having to open the dashboard.

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