DBM Agent Integration Overhead

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.

Overview

Database Monitoring runs on top of the base Datadog Agent. By default, it’s configured with optimal performance settings to minimize impact on your system. However, you have the flexibility to adjust parameters like data collection frequency and query sampling to better suit your workloads.

This page contains the results of integration overhead tests conducted against databases with Datadog Database Monitoring enabled.

Overhead testing results

Postgres integration overhead tests were run on an Amazon EC2 machine c5.xlarge instance (4 vCPUs, 8 GB RAM). The database used for the tests was a PostgreSQL 14.10 instance running on an Amazon RDS db.m5.large instance (2 vCPUs, 8 GB RAM). The database was running a TPC-C workload with 20 warehouses.

SettingCollection Interval
Check Min Collection Interval15s
Query Metrics Collection Interval10s
Query Samples Collection Interval10s
Settings Collection Interval600s
Schema Collection Interval600s
  • Agent Test version: 7.50.2
  • CPU: ~1% of the CPU used on average
  • Memory: ~300 MiB of RAM used (RSS memory)
  • Network bandwidth: ~30 KB/s ▼ | 30 KB/s ▲
  • Agent query overhead on database: ~1% CPU Time

Note: The network bandwidth is the sum of the incoming and outgoing traffic from the Agent to the monitored database and the Datadog backend.

MySQL integration overhead tests were run on an Amazon EC2 machine c5.xlarge instance (4 vCPUs, 8 GB RAM). The database used for the tests was a MySQL 8.0 instance running on an Amazon RDS db.m5.large instance (2 vCPUs, 8 GB RAM). The database was running a TPC-C workload with 20 warehouses.

SettingCollection Interval
Check Min Collection Interval15s
Query Metrics Collection Interval10s
Query Activities Collection Interval10s
Query Samples Collection Interval1s
Settings Collection Interval600s
  • Agent Test version: 7.50.2
  • CPU: ~2% of the CPU used on average
  • Memory: ~300 MiB of RAM used (RSS memory)
  • Network bandwidth: ~40 KB/s ▼ | 30 KB/s ▲
  • Agent query overhead on database: ~1% CPU Time

Note: The network bandwidth is the sum of the incoming and outgoing traffic from the Agent to the monitored database and the Datadog backend.

SQL Server integration overhead tests were run on an Amazon EC2 machine c5.xlarge instance (4 vCPUs, 8 GB RAM). The database used for the tests was a SQL Server 2019 Standard Edition instance running on an Amazon RDS db.m5.large instance (2 vCPUs, 8 GB RAM). The database was running a TPC-C workload with 20 warehouses.

SettingCollection Interval
Check Min Collection Interval15s
Query Metrics Collection Interval60s
Query Activities Collection Interval10s
Settings Collection Interval600s
  • Agent Test version: 7.50.2
  • CPU: ~1% of the CPU used on average
  • Memory: ~300 MiB of RAM used (RSS memory)
  • Network bandwidth: ~40 KB/s ▼ | 30 KB/s ▲
  • Agent query overhead on database: ~1% CPU Time

Note: The network bandwidth is the sum of the incoming and outgoing traffic from the Agent to the monitored database and the Datadog backend.

Oracle integration overhead tests were run on an Amazon EC2 machine c5.xlarge instance (4 vCPUs, 8 GB RAM). The database used for the tests was a Oracle 19c instance running on an Amazon RDS db.m5.large instance (2 vCPUs, 8 GB RAM). The database was running a TPC-C workload with 20 warehouses.

SettingCollection Interval
Check Min Collection Interval10s
Query Metrics Collection Interval60s
Query Activities Collection Interval10s
  • Agent Test version: 7.53.0
  • CPU: ~0.2% of the CPU used on average
  • Memory: ~270 MiB of RAM used (RSS memory)
  • Network bandwidth: ~6 KB/s ▼ | 4 KB/s ▲
  • Agent query overhead on database: ~0.2% CPU Time

Note: The network bandwidth is the sum of the incoming and outgoing traffic from the Agent to the monitored database and the Datadog backend.