Diagnose and resolve database performance issues faster with Database Investigator

Database Investigator is a new agentic feature within Datadog Database Monitoring that automates root cause analysis for database performance issues. It correlates workload metrics, query samples, execution plans, distributed traces, and logs to surface root causes and concrete remediation steps in plain language. The post walks through three real-world scenarios: diagnosing a latency spike caused by an index scan flipping to a sequential scan, detecting connection pool exhaustion from idle-in-transaction sessions, and identifying WAL replay stalls causing replication lag. In each case, Database Investigator reduces what could be hours of manual investigation to minutes, making database diagnostics accessible to engineers without deep database expertise.