[Webinar] Discover key trends and best practices in Kubernetes observability with DevOps expert, Viktor Farcic.Register now
Our recognition in the inaugural Gartner MQ for DEM

AWS Database Migration Service Monitoring

AWS Database Migration Service - Overview

AWS Database Migration Service (DMS) is a managed migration service from Amazon Web Services (AWS) that enables seamless database migration with minimal downtime. AWS DMS supports migrations between various database engines (Amazon RDS, Aurora, Oracle, SQL Server, MySQL, PostgreSQL, etc.) whether on-premises or in the cloud.

AWS DMS operates using two key components: Replication Instance and Replication Task.

  • Replication Instance provide the compute and memory resources needed for migration. They extract, transform, and load (ETL) data from the source to the target database.
  • Replication Task define how data is transferred, supporting full-load migration, ongoing change data capture (CDC), or both.

AWS DMS ensures reliable, automated data replication while monitoring migration progress, replication latency, and performance metrics to optimize efficiency.

Creating a new AWS Database Migration Service monitor

To learn how to create a new AWS DMS Replication Instance/AWS DMS Replication Task monitor, refer here.

Monitored Parameters

Go to the Monitors Category View by clicking the Monitors tab. Click on the Database Migration Service instance available under Amazon in the Cloud Apps section. Displayed below is the Amazon Database Migration Service bulk configuration view distributed into three tabs:

  • Availability tab gives the availability history for the past 24 hours or 30 days.
  • Performance tab gives the health status and events for the past 24 hours or 30 days.
  • List view tab enables you to perform bulk admin configurations.

By clicking on the respective monitor name from the list, you'll be taken to the Amazon Database Migration Service dashboard.

Click on the Amazon DMS Replication Instance monitor to see all the metrics listed under the following tabs:

Click on the Amazon DMS Replication Task monitor to see all the metrics listed under the following tabs:

Amazon DMS Replication Instance Metrics

Amazon DMS Replication Instance - Performance Overview

ParameterDescription
INSTANCE INFORMATION
Instance State The status of the replication instance.
Possible Values: Available, Creating, Deleted, Deleting, Failed, Modifying, Upgrading, Rebooting, Resetting-Master-Credentials, Storage-Full, Incompatible-Credentials, Incompatible-Network, Maintenance.
CPU UTILIZATION
CPU Utilization The percentage of allocated vCPU (virtual CPU) currently utilized by the instance at the time of polling (in %).
STORAGE UTILIZATION
Storage Utilization The percentage of allocated storage currently utilized by this DMS replication instance at the time of polling (in %).
NETWORK I/O THROUGHPUT
Incoming traffic The average amount of incoming network traffic on the replication instance per second, including both customer database traffic and AWS DMS traffic used for monitoring and replication between the poll interval (in MB/s).
Outgoing traffic The average amount of outgoing network traffic on the replication instance per second, including both customer database traffic and AWS DMS traffic used for monitoring and replication between the poll interval (in MB/s).
DISK THROUGHPUT
Read Throughput The average amount of data read from the disk per second between the poll interval (in MB/s).
Write Throughput The average amount of data written to the disk per second between the poll interval (in MB/s).
DISK IOPS
Read Operations The average number of disk read I/O operations per second between the poll interval (in operations/s).
Write Operations The average number of disk write I/O operations per second between the poll interval (in operations/s).
LATENCY
Read Latency The average amount of time taken per disk I/O (input) operation between the poll interval (in ms).
Write Latency The average amount of time taken per disk I/O (output) operation between the poll interval (in ms).
STORAGE USAGE
Used Storage The average amount of storage space utilized at the time of polling (in GB).
Available Storage The average amount of storage space available at the time of polling (in GB).
Total Storage The total amount of storage space (in GB).
DISK QUEUE DEPTH
Disk Queue Depth The average number of outstanding read/write requests waiting to access the disk between the poll interval.
AVAILABLE MEMORY
Available Memory The average amount of random access memory available at the time of polling (in MB).
SWAP USAGE
Swap Usage The average amount of swap space used on the replication instance at the time of polling (in MB).

Amazon DMS Replication Instance - Tasks

ParameterDescription
Tasks
Task ID The user-defined identifier for the replication task.
Task ARN The Amazon Resource Name (ARN) that uniquely identifies the replication task.
Type Indicates the type of migration for the task.
Possible Values: Full Load, CDC, Full-Load-and-CDC.
Source Endpoint The source database endpoint for the replication task.
Target Endpoint The target database endpoint for the replication task.
Status The status of the replication task.
Stop Reason A message describing the reason why the replication task stopped, if applicable.

Amazon DMS Replication Instance - Events

ParameterDescription
Events
Date The date and time when the event occurred.
Category The category associated with the event.
Type The type of AWS DMS resource that generated the event.
Possible Values: replication-instance, endpoint, replication-task.
Source ID The identifier of the AWS DMS resource that generated the event.
Message A detailed message about the event.

Amazon DMS Replication Instance - Configuration

ParameterDescription
CONFIGURATION
Instance ID The unique identifier for the replication instance.
Availability Zone The Availability Zone of the instance.
Network Type The type of IP address protocol used by a replication instance.
Engine Version The engine version number of the replication instance.
Instance Class The compute and memory capacity of the replication instance, as determined by the specified replication instance class.
Creation Date The date and time when the replication instance was created.
Free Instance Expiration The expiration date of the free replication instance that is part of the Free DMS program.
DNS Server The DNS name servers supported for the replication instance to access the on-premise source or target database.
Public Accessibility Indicates the accessibility state for the replication instance.
Maintenance Window The maintenance window times for the replication instance.
VPC The ID of the VPC.
VPC Security Groups The VPC security group for the instance.
Multi AZ Specifies whether the replication instance is a Multi-AZ deployment.
Secondary Availability Zone The Availability Zone of the standby replication instance in a Multi-AZ deployment.
KMS Key ID The KMS key identifier that is used to encrypt the data on the replication instance.
Auto Minor Version Upgrade Indicates if minor version upgrades will be automatically applied to the instance.
SUBNET GROUP DETAILS
Subnet Group ID The identifier of the replication instance subnet group.
Subnet Group Description A description for the replication subnet group.
Subnet Group Status The status of the subnet group.
Subnets The subnets that are in the subnet group.
CHANGE TYPE
Allocated Storage The amount of storage allocated for the replication instance.
Engine Version The engine version number of the replication instance.
Multi AZ Specifies whether the replication instance is a Multi-AZ deployment.
Instance Class The compute and memory capacity of the replication instance as defined for the specified replication instance class.

Amazon DMS Replication Task Metrics

Amazon DMS Replication Task - Performance Overview

ParameterDescription
TASK OVERVIEW
Task State The status of the replication task.
Possible Values: Moving, Creating, Deleting, Failed, Failed-Move, Modifying, Ready, Running, Starting, Stopped, Stopping, Testing.
Stop Reason The reason the replication task was stopped.
Last Failure Message The last error (failure) message generated for the replication task.
Number of Running Tasks The total number of tasks running between the poll interval.
Number of Recovery Events The total number of recoveries between the poll interval.
CPU UTILIZATION
CPU Utilization The percentage of CPU utilized by the task at the time of the poll (in %).
MIGRATION PROGRESS
Migration Progress The percentage of completion for the full load migration task (in %).
MEMORY USAGE
Memory Usage The amount of memory used by the task in between the poll interval (in MB).
TABLE LOAD SUMMARY
Number of Tables Loaded The number of tables loaded for this task.
Number of Tables Loading The number of tables currently loading for this task.
Number of Tables Queued The number of tables queued for this task.
Number of Errors Occurred The number of errors that have occurred during this task.
FULL LOAD THROUGHPUT BANDWIDTH
Full Load Throughput - Source Bandwidth The average amount of outgoing data transmitted from a full load for the source, measured in MB per second, between the poll interval (in MB/s).
Full Load Throughput - Target Bandwidth The average amount of outgoing data transmitted from a full load for the target, measured in MB per second, between the poll interval (in MB/s).
Full Load Throughput - Total Bandwidth The average amount of outgoing data transmitted from a full load, measured in MB per second, between the poll interval (in MB/s).
FULL LOAD THROUGHPUT ROWS
Full Load Throughput - Source Rows The average number of incoming changes from a full load for the source, measured in rows per second, between the poll interval (in rows/s).
Full Load Throughput - Target Rows The average number of outgoing changes from a full load for the target, measured in rows per second, between the poll interval (in rows/s).
Full Load Throughput - Total Rows The average number of outgoing changes from a full load (including the spurce and target) between the poll interval (in rows/s).
SWAP USAGE
Swap Usage The average amount of swap space utilized by the task between the poll interval (in MB).
ELAPSED TIME
Elapsed Time The total duration for which the task has been running (in ms).

Amazon DMS Replication Task - CDC

ParameterDescription
INCOMING CDC CHANGES
Incoming CDC Changes The average number of change events waiting to be applied to the target between the poll interval.
CDC LATENCY
Source CDC Latency The average time gap between the last event captured from the source and the current system timestamp of the AWS DMS instance between the poll interval (in ms).
Target CDC Latency The average time gap between the first event waiting to commit on the target and the current timestamp of the AWS DMS instance, measured between the poll interval (in ms).
Total CDC Latency The total time gap between the last captured event from the source and the first unconfirmed event at the target between the poll interval (in ms).
CDC MEMORY CHANGES
CDC Memory - Source Changes The average number of rows accumulating in a memory and waiting to be committed from the source between the poll interval.
CDC Memory - Target Changes The average number of rows accumulating in a memory and waiting to be committed to the target between the poll interval.
CDC Memory - Total Changes The total number of rows accumulating in a memory and waiting to be committed between the poll interval.
CDC DISK CHANGES
CDC Disk - Source Changes The average number of rows accumulating on disk and waiting to be committed from the source between the poll interval.
CDC Disk - Target Changes The average number of rows accumulating on disk and waiting to be committed to the target between the poll interval.
CDC Disk - Total Changes The total number of rows accumulating on disk and waiting to be committed between the poll interval.
CDC THROUGHPUT BANDWIDTH
CDC Throughput - Source Bandwidth The average amount of outgoing data transmitted for the source between the poll interval (in MB/s).
CDC Throughput - Target Bandwidth The average amount of outgoing data transmitted for the target between the poll interval (in MB/s).
CDC Throughput - Total Bandwidth The total outgoing data transmitted in MB per second between the poll interval (in MB/s).
CDC THROUGHPUT ROWS
CDC Throughput - Source Rows The average number of rows transmitted per second from the source between the poll interval (in rows/s).
CDC Throughput - Target Rows The average number of rows transmitted per second to the target between the poll interval (in rows/s).
CDC Throughput - Total Rows The tota number of rows transmitted per second between the poll interval (in rows/s).

Amazon DMS Replication Task - Validation

ParameterDescription
RECORD VALIDATION STATISTICS
Succeeded Validations The number of records validated successfully between the poll interval.
Attempted Validations The number of records where validation was attempted between the poll interval.
Failed Validations The number of records where validation failed between the poll interval.
Suspended Validations The number of records where validation was suspended between the poll interval.
Pending Validations The number of records where validation is pending between the poll interval.
BULK VALIDATION QUERY
Bulk Validation Query - Source Latency The average time taken to read a bulk set of data from the source endpoint during validation, between the poll interval (in ms).
Bulk Validation Query - Target Latency The average time taken to read a bulk set of data from the target endpoint during validation, between the poll interval (in ms).
Bulk Validation Query - Total Latency The average time taken to read a bulk set of data during validation across both the source and target endpoints, measured between the poll interval (in ms).
ITEM VALIDATION QUERY
Item Validation Query - Source Latency The average time taken to read ongoing changes from the source endpoint during validation, between the poll interval (in ms).
Item Validation Query - Target Latency The average time taken to read ongoing changes from the target endpoint during validation, between the poll interval (in ms).
Item Validation Query - Total Latency The average time taken to read ongoing changes during validation across both the source and target endpoints, measured between the poll interval (in ms).

Amazon DMS Replication Task - Endpoints

ParameterDescription
SOURCE ENDPOINT
Endpoint Name The name of the endpoint associated with the DMS replication task.
Source Endpoint The unique identifier of the endpoint associated with the DMS replication task.
Endpoint Type Indicates the type of the endpoint in the DMS replication task.
Possible values: SOURCE/TARGET.
Source Endpoint Status Indicates the current status of the source endpoint in the DMS replication task.
Engine Name The engine name of the endpoint.
Engine Display Name The display name of the engine for the endpoint.
Database Name The name of the database associated with the endpoint.
Server Name The server name where the endpoint is hosted.
Port The port used for the connection to the endpoint in the DMS replication task.
SSL Mode The SSL mode used for the connection to the endpoint.
Username The username used for authentication to the endpoint.
KMS Key ID The KMS key ID used for encrypting data in the endpoint associated with the DMS replication task.
TARGET ENDPOINT
Endpoint Name The name of the endpoint associated with the DMS replication task.
Target Endpoint The unique identifier of the endpoint associated with the DMS replication task.
Endpoint Type Indicates the type of the endpoint in the DMS replication task.
Possible values: SOURCE/TARGET.
Source Endpoint Status Indicates the current status of the target endpoint in the DMS replication task.
Engine Name The engine name of the endpoint.
Engine Display Name The display name of the engine for the endpoint.
Database Name The name of the database associated with the endpoint.
Server Name The server name where the endpoint is hosted.
Port The port used for the connection to the endpoint in the DMS replication task.
SSL Mode The SSL mode used for the connection to the endpoint.
Username The username used for authentication to the endpoint.
KMS Key ID The KMS key ID used for encrypting data in the endpoint associated with the DMS replication task.

Amazon DMS Replication Task - Configuration

ParameterDescription
CONFIGURATION
Resource Name The resource part of the Task ARN.
Replication Instance The resource name of the replication instance.
Instance ID The unique identifier of the replication instance.
Source Endpoint The ARN that uniquely identifies the source endpoint.
Target Endpoint The ARN that uniquely identifies the target endpoint.
Type The type of migration.
Possible Values: full-load, cdc, full-load-and-cdc.
Recovery Checkpoint Indicates the last checkpoint that occurred during a change data capture (CDC) operation.
CDC Start Position Indicates when you want a change data capture (CDC) operation to start.
CDC Stop Position Indicates when you want a change data capture (CDC) operation to stop.
Task Creation Date The date the replication task was created.
Task Scheduled Start Date The date the replication task is scheduled to start.
Start Date The date the replication task was started either with a fresh start or a resume.
Stop Date The date the replication task was stopped.
Fresh Start Date The date the replication task was started either with a fresh start or a target reload.
Full Load Start Date The date the replication task full load was started.
Full Load Finish Date The date the replication task full load was completed.

Thank you for your feedback!

Was this content helpful?

We are sorry. Help us improve this page.

How can we improve this page?
Do you need assistance with this topic?
By clicking "Submit", you agree to processing of personal data according to the Privacy Policy.
Back to Top