Exploring Database Hosts

Cette page n'est pas encore disponible en français, sa traduction est en cours.
Si vous avez des questions ou des retours sur notre projet de traduction actuel, n'hésitez pas à nous contacter.
The Databases page in Datadog

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 any host in the list to open a details panel:

The details panel for a single database host on the Databases page

In addition to a filterable graph of active connections for that host, the host details panel displays the following features.

Top queries

On the Top Queries tab of the host details panel, you can sort the most common queries by maximum duration, average latency, and more.

The Top Queries tab of the details panel for a single database host on the Databases page

Click on any query statement to open a details panel that includes:

  • query insights
  • graphs for average latency and other key metrics
  • explain plans
  • blocking activity
  • hosts that have run the query
  • calling services
The details panel for an individual top query

Stored procedures

Where supported, the Top Queries tab includes a Stored Procedures section that lists each stored procedure by name, along with its average duration, logical reads count, logical writes count, and more. Expand a stored procedure to view its individual SQL queries, and click on a query to view its details panel.

A list of stored procedures, with one expanded to show its SQL query

Metrics

This feature is in beta.

On the Metrics tab of the host details panel, you can view and filter metrics for system health, query activity, blocking operations, function performance, and other key areas.

The Metrics tab of the details panel for a single database host on the Databases page

Active connections

The Active Connections tab of the host details panel displays the live queries being executed on the host. Click on a query statement to open a panel that includes event attributes, related traces, and other relevant details.

The Active Connections tab of the details panel for a single database host on the Databases page

Schema

This feature is in beta.

Use the Schema tab to explore database structures, tables, columns, data types, existing foreign keys, and indexing strategies for every database on a host.

The Schema tab of the details panel for a single database host on the Databases page

Blocking queries

On the Blocking Queries tab of host details panel, you can view visualizations for:

  • blocking query durations
  • blocking query executions
  • the number of waiting queries

You can search and filter the queries or samples. Click any individual query row to view details.

The Blocking Queries tab of the details panel for a single database host on the Databases page

Calling services

On the Calling Services tab of the host details panel, you can view the list of services that have called the host. The displayed service information includes when the service was deployed, the number of requests made to the host per second, how many database queries were executed, and more.

The Calling Services tab of the details panel for a single database host on the Databases page

Click any service row to view its APM dashboard.

Configuration details

The host must have collect_settings enabled in its instance configuration for this feature to work properly.

The Configuration tab of the host details panel provides a direct view into the host’s configuration parameters without compromising database security. Use it to identify misconfigured database parameters and adjust settings to optimize database performance.

The Configuration tab of the details panel for a single database host on the Databases page