How can I enable monitoring for an AWS Database Migration Service (AWS DMS) task?

You can use Amazon CloudWatch to monitor the progress of your DMS task, the resources used, and the network activity used. You can monitor an AWS DMS task by using the AWS DMS console, the AWS Command Line Interface (AWS CLI), or the AWS DMS API

Enable task logging

  1. Open the AWS DMS console, and then choose Tasks from the navigation pane.
  2. Choose your task, and then choose Modify.
  3. Expand Task Settings, and then check the box for Enable logging.
  4. Choose Modify.

Check the task status

  1. Open the AWS DMS console, and then choose Tasks from the navigation pane.
  2. Choose the task that you want to monitor, and then review the Status column. For more information about the status of your task, see Task Status.
  3. Choose the Table Statistics view.
  4. Review the values in the columns for Tables loaded, Tables loading, Tables queued, and Tables errored.

Monitor the task's progress

  1. Open the AWS DMS console, and then choose Tasks from the navigation pane.
  2. Choose your task, and then choose the Table statistics view.
  3. Check the Load state column.

View the Amazon CloudWatch metrics

  1. Open the AWS DMS console, and then choose Tasks from the navigation pane.
  2. Choose your running task, and then choose the Logs view.
  3. Choose the Amazon CloudWatch link to see metrics in the Amazon CloudWatch console.
  4. Return to the AWS DMS console, and then choose Tasks from the navigation pane.
  5. Choose your task, and then choose the Task monitoring to view the current metrics for your replication task.
  6. Check the metrics for CDCLatencySource and CDCLatencyTarget to identify potential latency in the source or target. For more information, see Monitoring Replication Tasks Using Amazon CloudWatch.

View the table state

  1. Open the AWS DMS console, and then choose Tasks from the navigation pane.
  2. Choose your task, and then choose Overview to view the configuration of the AWS DMS task.
  3. Choose the Task settings drop-down to view your current task settings.

View the replication instance state

  1. Open the AWS DMS console, and then choose Replication instances from the navigation pane.
  2. Choose the replication instance in use, and then choose the Monitoring view.
  3. Review the metrics for CPU utilization, freeable memory, free storage space, and SWAP usage.

Use advanced settings

  1. Open the AWS DMS console, and then choose Tasks from the navigation pane.
  2. Choose your task, and then choose Modify.
  3. Choose Advanced Settings, and then choose Control table settings.
  4. In the Create control table in target using schema field, enter the name of your schema on the target database where DMS can create its control tables.
  5. In the History timeslot (minutes), enter the amount of time you want each history record to stay in the replication history table.
  6. Apply Exceptions - wsdms_apply_exceptions is always enabled. Optionally, you can add the following Control tables to monitor additional details about the task:
    Replication Status - awsdms_status
    Suspended Tables - awsdms_suspended_tables
    Replication History - awsdms_history
    Note: These control tables are created in the target instance, and they can be viewed only by using a SELECT query in the target control schema in the target database instance.

Did this page help you? Yes | No

Back to the AWS Support Knowledge Center

Need help? Visit the AWS Support Center

Published: 2018-09-18