Loading...


Updated 1 Sep 2026 • 5 mins read

Database monitoring is how you catch slow queries, saturation, and replication problems before they become outages or runaway cost. This guide covers what to track, which database monitoring tools to use, from open-source Prometheus and Percona to Datadog DBM and native cloud tools, and what it all costs.
A surprising share of production incidents and cloud spend trace back to the same place: the database. A query that was fast at ten thousand rows crawls at ten million, a connection pool quietly exhausts, a replica falls behind, and the first anyone hears of it is a paged engineer or a doubled bill. The database is where problems start quietly and surface loudly, which is exactly why monitoring it well pays for itself.
This guide is a practical map of database monitoring in 2026: the metrics worth tracking and why, the tools that track them across open-source, commercial, and native-cloud options, and what each approach actually costs, including the trap where the monitoring itself becomes an expensive line item.
The short version Track four families of signal: query performance (slow queries, execution time, wait events), throughput and latency, resource saturation (CPU, memory, IOPS, connections), and availability (replication lag, errors, locks). For tooling, open-source Prometheus plus Grafana and Percona PMM are the free, DIY baseline; Datadog Database Monitoring, Dynatrace, and New Relic add cross-stack context at a price; and native tools like RDS Performance Insights and MongoDB Atlas come built in. Costs range from free (self-hosted) to roughly $70 per host per month for Datadog DBM, and high-cardinality telemetry gets expensive fast.
Effective database monitoring is not about collecting every metric; it is about watching the few families of signal that predict trouble. The essentials:
| Signal family | Key metrics | Why it matters |
|---|---|---|
| Query performance | Slow queries, execution time, explain plans, wait events | Slow queries are the top cause of database pain and cost |
| Throughput & latency | Queries per second, transactions per second, p95/p99 latency | Shows load and where response time degrades |
| Resource saturation | CPU, memory, disk usage, IOPS, active connections | Saturation causes stalls, timeouts, and forced scaling |
| Availability & integrity | Replication lag, error rates, locks and deadlocks, cache hit ratio | Predicts outages, data staleness, and contention |
Two metrics deserve special attention. Query Analytics, ranking your slowest and most frequent queries, is where most real optimization happens, since a single bad query can dominate load. And IOPS and disk saturation are where database performance meets cloud cost, because provisioned IOPS and storage are billed whether or not you use them; our guide to IOPS explains that link.
Tools fall into three camps, and the right choice depends on whether you are a database-deep team or a cross-stack one.
| Tool | Type | Best for |
|---|---|---|
| Prometheus + Grafana | Open-source, self-hosted | DIY metrics with full control |
| Percona PMM | Open-source, self-hosted | Deep, free MySQL/PostgreSQL/MongoDB monitoring |
| Datadog DBM | Commercial SaaS | Cross-stack query and app correlation |
| Dynatrace | Commercial SaaS | AI-driven analysis at enterprise scale |
| New Relic | Commercial SaaS | Full-stack teams already on New Relic |
| pganalyze | PostgreSQL specialist | Automated Postgres tuning and index advice |
| Native cloud (RDS PI, Atlas) | Built-in | Zero-setup monitoring for managed databases |
Prometheus with Grafana, using exporters like postgres_exporter and mysqld_exporter, is the most widely deployed open-source stack: free, endlessly flexible, and yours to run. Percona PMM goes further for open-source databases, bundling Prometheus and Grafana with Query Analytics into a cohesive, free product with the deepest free MySQL monitoring available. Both trade money for operational effort, you assemble and run the stack yourself.
Datadog Database Monitoring adds query-level metrics, explain plans, and wait-event analysis, and crucially links database performance to application telemetry so you can trace a slow query to the code and deploy behind it. Dynatrace brings AI-driven root-cause analysis, and New Relic suits teams already on its platform. These are powerful for cross-stack incident investigation, at a commercial price; our Datadog pricing guide and application monitoring tools roundup go deeper.
Do not overlook what your provider already includes. AWS RDS Performance Insights, MongoDB Atlas's Performance Advisor, and the equivalents on Azure and GCP offer solid, zero-setup monitoring for managed databases, often free within retention limits. For teams running managed databases, native tools cover the basics before you pay for anything, and they fit naturally into the wider AWS picture we cover in understanding AWS pricing.
Database monitoring pricing follows a few models, and the model matters as much as the sticker rate:
The trap to watch is that high-cardinality database telemetry at scale can make per-host and ingestion pricing expensive fast, so monitoring becomes a cost center of its own. Treat monitoring spend like any other cloud line, worth allocating and optimizing, as in our cloud cost optimization strategies guide.
Match the tool to your team and constraints:
Database monitoring is one of those investments that looks optional right up until the night it is not. The goal is not a wall of dashboards; it is a short, honest set of signals, what is slow, what is saturated, what is falling behind, delivered by a tool whose cost you understand and control. Get those signals right and most database incidents turn into a routine fix instead of an outage.
So start from the four signal families, not the tool list. Decide whether you are a database-deep team or a cross-stack one, pick the cheapest option that covers your signals with room to grow, and keep an eye on the meter, because at scale the monitoring can quietly cost as much as the database it watches. Watched well, the database stops being the thing that surprises you and becomes the thing you trust.
Four families of signal: query performance (slow queries, execution time, wait events), throughput and latency, resource saturation (CPU, memory, IOPS, connections), and availability and integrity (replication lag, errors, locks, cache hit ratio). Slow queries and saturation are the most common sources of trouble.
Open-source Prometheus with Grafana and Percona PMM are the free, DIY baseline. Datadog Database Monitoring, Dynatrace, and New Relic add cross-stack context commercially. pganalyze is a strong PostgreSQL specialist, and native tools like RDS Performance Insights and MongoDB Atlas come built in.
It ranges from free (self-hosted Prometheus, Grafana, or Percona PMM, where you pay in compute and effort) to roughly $70 per host per month for Datadog DBM and $7 to $58 for Dynatrace. Ingestion-based tools bill around $0.15 to $0.35 per GB, which can spike at scale.
Often, yes. Prometheus with Grafana and Percona PMM provide deep, capable monitoring for free, and PMM's Query Analytics is genuinely strong for finding slow queries. The trade-off is operational effort, since you assemble and run the stack rather than buying a finished product.
Database specialists like pganalyze go deep on one engine with automated tuning but tell you little about the rest of your stack. Cross-stack platforms like Datadog and Dynatrace correlate a slow query with application errors and deploys, which matters for incident investigation.
Native tools like AWS RDS Performance Insights and MongoDB Atlas cover the basics for free within retention limits, which is enough for many teams. Add a dedicated tool when you need deeper query analysis, cross-stack correlation, or longer retention than the native option provides.
Because per-host and ingestion-based pricing scales with your infrastructure and telemetry volume, and database monitoring produces high-cardinality data. At scale, that can make the monitoring bill rival the database itself, so choose the pricing model and retention deliberately.