Amazon DMS

Crawler

Overview

Amazon Database Migration Service (DMS) is a cloud service that makes it easy to migrate relational databases, data warehouses, NoSQL databases, and other types of data stores.

Enable this integration to see all your DMS metrics in Datadog.

Setup

Installation

If you haven’t already, set up the Amazon Web Services integration first.

Metric collection

In the AWS integration tile, ensure that Database Migration Service is checked under metric collection.
Install the Datadog - Amazon DMS integration.

Log collection

Enable logging

Configure Amazon Database Migration Service to send logs either to a S3 bucket or to Cloudwatch.

Note: If you log to a S3 bucket, make sure that amazon_dms is set as Target prefix.

Send logs to Datadog

If you haven’t already, set up the Datadog log collection AWS Lambda function.
Once the lambda function is installed, manually add a trigger on the S3 bucket or Cloudwatch log group that contains your Amazon Amazon DMS logs in the AWS console:
- Add a manual trigger on the S3 bucket
- Add a manual trigger on the Cloudwatch Log Group

Data Collected

Metrics

aws.dms.cdcchanges_disk_source (gauge)	Amount of rows accumulating on disk and waiting to be committed from the source Shown as row
aws.dms.cdcchanges_disk_target (gauge)	Amount of rows accumulating on disk and waiting to be committed to the target Shown as row
aws.dms.cdcchanges_memory_source (gauge)	Amount of rows accumulating in a memory and waiting to be committed from the source Shown as row
aws.dms.cdcchanges_memory_target (gauge)	Amount of rows accumulating in a memory and waiting to be committed to the target Shown as row
aws.dms.cdcincoming_changes (gauge)	Total row count of changes for the task Shown as row
aws.dms.cdclatency_source (gauge)	Latency reading from source Shown as second
aws.dms.cdclatency_target (gauge)	Latency writing to the target Shown as second
aws.dms.cdcthroughput_bandwidth_source (gauge)	Incoming task network bandwidth from the source Shown as kibibyte
aws.dms.cdcthroughput_bandwidth_target (gauge)	Outgoing task network bandwidth for the target Shown as kibibyte
aws.dms.cdcthroughput_rows_source (gauge)	Incoming task changes from the source Shown as row
aws.dms.cdcthroughput_rows_target (gauge)	Outgoing task changes for the target Shown as row
aws.dms.cpuutilization (gauge)	The amount of CPU used. Shown as byte
aws.dms.free_storage_space (gauge)	The amount of available storage space Shown as byte
aws.dms.freeable_memory (gauge)	The amount of available random access memory. Shown as byte
aws.dms.full_load_throughput_bandwidth_source (gauge)	Incoming network bandwidth from a full load from the source Shown as kibibyte
aws.dms.full_load_throughput_bandwidth_target (gauge)	Outgoing network bandwidth from a full load for the target Shown as kibibyte
aws.dms.full_load_throughput_rows_source (gauge)	Incoming changes from a full load from the source in rows per second Shown as row
aws.dms.full_load_throughput_rows_target (gauge)	Outgoing changes from a full load for the target Shown as row
aws.dms.network_receive_throughput (gauge)	The incoming (Receive) network traffic on the DB instance including both customer database traffic and Amazon RDS traffic used for monitoring and replication. Shown as byte
aws.dms.network_transmit_throughput (gauge)	The outgoing (Transmit) network traffic on the DB instance including both customer database traffic and Amazon RDS traffic used for monitoring and replication Shown as byte
aws.dms.read_iops (gauge)	The average number of disk I/O operations per second. Shown as operation
aws.dms.read_latency (gauge)	The average amount of time taken per read disk I/O operation Shown as second
aws.dms.read_throughput (gauge)	The average number of bytes read from disk per second. Shown as byte
aws.dms.swap_usage (gauge)	The amount of swap space used on the DB Instance Shown as byte
aws.dms.write_iops (gauge)	The average number of disk I/O operations per second Shown as operation
aws.dms.write_latency (gauge)	The average amount of time taken per write disk I/O operation Shown as second
aws.dms.write_throughput (gauge)	The average number of bytes written to disk per second. Shown as byte

Events

The Amazon DMS integration does not include any events.

Service Checks

The Amazon DMS integration does not include any service checks.

Troubleshooting

Need help? Contact Datadog support.