Join an enablement webinar session
With Database Monitoring, learn how to quickly pinpoint costly and slow queries. Drill into precise execution details to address bottlenecks.
Datadog Database Monitoring provides deep visibility into databases across all of your hosts. Dig into historical query performance metrics, explain plans, and host-level metrics all in one place, to understand the health and performance of your databases and troubleshoot issues as they arise.
Getting started
Datadog Database Monitoring supports self-hosted and managed cloud versions of Postgres, MySQL, Oracle, SQL Server, MongoDB, and Amazon DocumentDB. To get started with Datadog Database Monitoring, configure your database and install the Datadog Agent. For setup instructions, select your database technology:
Postgres
MySQL
Oracle
SQL Server
MongoDB
Amazon DocumentDB
Explore Datadog Database Monitoring
Navigate to Database Monitoring in Datadog.
The Query Metrics view shows historical query performance for normalized queries. Visualize performance trends by infrastructure or custom tags such as datacenter availability zone, and set alerts for anomalies.
- Identify slow queries and which queries are consuming the most time.
- Show database-level metrics not captured by APM such as rows updated/returned.
- Filter and group queries by arbitrary dimensions such as team, user, cluster, and host.
Explore query samples
The Query Samples view helps you understand which queries are running at a given time. Compare each execution to the average performance of the query and related queries.
- Identify unusually slow but infrequent queries not captured by metrics.
- Find outliers in a query’s execution time or execution cost.
- Attribute a specific query execution to a user, application, or client host.
Understand before you run
Explain Plans help you understand how the database plans to execute your queries.
- Step through each operation to identify bottlenecks.
- Improve query efficiency and save on costly sequential scans on large tables.
- See how a query’s plan changes over time.
Visualize everything on enriched dashboards
Quickly pinpoint problem areas by viewing database and system metrics together on enriched integration dashboards for both self-hosted and cloud-managed instances. Clone dashboards for customization and enhancement with your own custom metrics. Click the Dashboards link at the top of the Query Metrics and Query Samples pages to go to the Database Monitoring dashboards.
On the Databases page, you can assess the health and activity of your database hosts. Sort and filter the list to prioritize hosts with triggered alerts, high query volume, and other criteria. Click on an individual host to view details such as its configuration, common blocking queries, and calling services. See Exploring Database Hosts for details.
View optimization recommendations
The Recommendations page highlights problems and optimization opportunities, helping you save time by prioritizing what’s most important. Select a recommendation to view details, including a summary of the problem, as well as potential next steps to address the issue.
Further Reading
Try Monitoring a Postgres Database with Datadog DBM in the Learning Center
The Datadog Learning Center is full of hands-on courses to help you learn about this topic. Enroll at no cost to identify inefficiencies and optimize your Postgres database.
Additional helpful documentation, links, and articles:
