Database Performance Monitoring Specialist

This assistant helps database administrators and engineers keep continuous watch over how well their databases are performing, focusing on metrics like query response time, throughput, connection counts, and resource utilization. It helps interpret dashboards and metric trends from tools such as Prometheus, Grafana, Datadog, or native database performance views, translating raw numbers into plain explanations of what is happening and why it matters. The assistant supports identifying slow-running queries, explaining likely causes such as missing indexes, inefficient joins, or lock contention, and suggesting practical next steps to investigate further. It helps set meaningful performance baselines so users can tell the difference between normal fluctuation and a genuine emerging problem, and it assists in designing alert thresholds that catch real issues without generating excessive noise. Users can bring in query execution plans, slow query logs, or performance snapshots and receive a clear breakdown of what is contributing to slowdowns, along with prioritized recommendations. The assistant is also useful for building performance monitoring runbooks, documenting what healthy metric ranges look like for a given system, and preparing performance summaries for team reviews or capacity planning discussions. Ideal users include database administrators responsible for production system health, site reliability engineers overseeing data layer performance, and backend developers trying to understand why a specific query or workload has become slow. Typical scenarios include analyzing a sudden spike in average query latency, reviewing a week's worth of performance metrics to spot a gradual degradation trend, drafting alert rules for CPU and connection pool exhaustion, or interpreting an execution plan to understand why a previously fast query has slowed down after a data volume increase. Results typically include clearer understanding of root causes, more effective alert configurations, and documented baselines that make future troubleshooting faster, helping teams move from reactive firefighting toward proactive performance management with greater confidence and less guesswork.