AWS Database Migration Service

AWS Database Migration Service (DMS) is a managed migration and replication service that helps move your database and analytics workloads to AWS.

Cisco Cloud Observability supports monitoring the following AWS DMS entities:

DMS replication task: An entity that can migrate data between the source and target data stores, apply cached changes, and perform ongoing replication.
DMS replication instance: A managed Amazon Elastic Compute Cloud (Amazon EC2) instance that hosts one or more replication tasks.
DMS endpoint: An endpoint that provides connection, data store type, and location information about your data store. AWS DMS uses this information to connect to a data store and migrate data from a source endpoint to a target endpoint. This entity has no metrics.

You must configure cloud connections to monitor this entity. See Set up Cisco AppDynamics Cloud Collectors to Monitor AWS.

Cisco Cloud Observability displays AWS entities on the Observe page. Metrics are displayed for specific entity instances in the list and detail views.

This document contains references to third-party documentation. Cisco AppDynamics does not own any rights and assumes no responsibility for the accuracy or completeness of such third-party documentation.

Detail View

To display the detail view for an AWS DMS entity:

Navigate to the Observe page.
Under Database & Storage, click AWS DMS Replication Instances.
The list view now displays.
Click an entity Name to display the detail view of a replication instance.
The detail view displays the metrics, key performance indicators, and properties (attributes) related to the instance you selected.

Navigate to the Observe page.
Under Database & Storage, click AWS DMS Replication Instances.
The AWS DMS Replication Instances list view now displays.
In the Relationships panel in the left-hand navigation panel, click AWS DMS Replication Tasks.
The AWS DMS Replication Task detail view now displays.
Click an entity Name to display the detail view of a replication task.
The detail view displays the metrics, key performance indicators, and properties (attributes) related to the instance you selected.

Metrics and Key Performance Indicators

Cisco Cloud Observability displays the following metrics and key performance indicators (KPIs) for AWS DMS. See Monitoring AWS DMS tasks.

Display Name	Source Metric	Description
Memory (Bytes)	`AvailableMemory`	An estimate of how much memory is available for starting new applications, without swapping. For more information, see `MemAvailable` value in `/proc/memInfo` section of the Linux man-pages.
	`FreeMemory`	The amount of physical memory available for use by applications, page cache, and for the kernel’s own data structures. For more information, see `MemFree` value in `/proc/memInfo` section of the Linux man-pages.
	`FreeableMemory`	The amount of available random access memory.
CPU (%)	`CPUUtilization`	The percentage of allocated vCPU (virtual CPU) currently in use on the instance.
Pending Requests	`DiskQueueDepth`	The number of outstanding read/write requests (I/Os) waiting to access the disk.
Free Storage Space (Bytes)	`FreeStorageSpace`	The amount of available storage space.
IOPS	`ReadIOPS`	The average number of disk read I/O operations per second.
IOPS	`WriteIOPS`	The average number of disk write I/O operations per second.
Disk Throughput (Bytes/s)	`ReadThroughput`	The average number of bytes read from disk per second.
Disk Throughput (Bytes/s)	`WriteThroughput`	The average number of bytes written to disk per second.
Latency (ms)	`ReadLatency`	The average amount of time taken per disk I/O (input) operation.
Latency (ms)	`WriteLatency`	The average amount of time taken per disk I/O (output) operation.
Swap Usage (Bytes)	`SwapUsage`	The amount of swap space used on the replication instance.
Network Throughput (Bytes/s)	`NetworkTransmitThroughput`	The outgoing (Transmit) network traffic on the replication instance, including both customer database traffic and AWS DMS traffic used for monitoring and replication.
Network Throughput (Bytes/s)	`NetworkReceiveThroughput`	The incoming (Receive) network traffic on the replication instance, including both customer database traffic and AWS DMS traffic used for monitoring and replication.

Display Name	Source Metric	Description
Full Load Througput Bandwidth to Target (KB/s)	`FullLoadThroughputBandwidthTarget`	Outgoing data transmitted from a full load for the target in KB per second.
Full Load Throughput to Target (Rows/s)	`FullLoadThroughputRowsTarget`	Outgoing changes from a full load for the target in rows per second.
CDC Incoming Changes (Count)	`CDCIncomingChanges`	The total number of change events at a point-in-time that are waiting to be applied to the target. Note that this is not the same as a measure of the transaction change rate of the source endpoint. A large number for this metric usually indicates AWS DMS is unable to apply captured changes in a timely manner, thus causing high target latency.
CDC Changes Memory (Rows)	`CDCChangesMemorySource`	Amount of rows accumulating in a memory and waiting to be committed from the source. You can view this metric together with `CDCChangesDiskSource`.
CDC Changes Memory (Rows)	`CDCChangesMemoryTarget`	Amount of rows accumulating in a memory and waiting to be committed to the target. You can view this metric together with `CDCChangesDiskTarget.`
CDC Changes Disk (Rows)	`CDCChangesDiskSource`	Amount of rows accumulating on disk and waiting to be committed from the source. You can view this metric together with `CDCChangesMemorySource`.
CDC Changes Disk (Rows)	`CDCChangesDiskTarget`	Amount of rows accumulating on disk and waiting to be committed to the target. You can view this metric together with `CDCChangesMemoryTarget`.
CDC Throughput (Rows/s)	`CDCThroughputRowsSource`	Incoming task changes from the source in rows per second.
CDC Throughput (Rows/s)	`CDCThroughputRowsTarget`	Outgoing task changes for the target in rows per second.
CDC Throughput Bandwidth to Target (KB/s)	`CDCThroughputBandwidthTarget`	Outgoing data transmitted for the target in KB per second. `CDCThroughputBandwidth` records outgoing data transmitted on sampling points. If no task network traffic is found, the value is zero. Because CDC does not issue long-running transactions, network traffic may not be recorded.
CDC Latency (s)	`CDCLatencySource`	The gap, in seconds, between the last event captured from the source endpoint and current system time stamp of the AWS DMS instance. `CDCLatencySource` represents the latency between source and replication instance. High `CDCLatencySource` means the process of capturing changes from source is delayed. To identify latency in an ongoing replication, you can view this metric together with `CDCLatencyTarget`. If both `CDCLatencySource` and `CDCLatencyTarget` are high, investigate `CDCLatencySource` first. `CDCSourceLatency` can be 0 when there is no replication lag between the source and the replication instance. `CDCSourceLatency` can also become zero when the replication task attempts to read the next event in the source's transaction log and there are no new events compared to the last time it read from the source. When this happens, the task resets the `CDCSourceLatency` to 0.
CDC Latency (s)	`CDCLatencyTarget`	The gap, in seconds, between the first event timestamp waiting to commit on the target and the current timestamp of the AWS DMS instance. Target latency is the difference between the replication instance server time and the oldest unconfirmed event id forwarded to a target component. In other words, target latency is the timestamp difference between the replication instance and the oldest event applied but unconfirmed by TRG endpoint (99%). When `CDCLatencyTarget` is high, it indicates the process of applying change events to the target is delayed. To identify latency in an ongoing replication, you can view this metric together with `CDCLatencySource`. If `CDCLatencyTarget` is high but `CDCLatencySource` isn’t high, investigate if: No primary keys or indexes are in the target Resource bottlenecks occur in the target or replication instance Network issues reside between replication instance and target
CPU Utilization (%)	`CPUUtilization`	The percentage of CPU being used by a task across multiple cores. The semantics of task `CPUUtilization` is slightly different from replication `CPUUtilization`. If 1 vCPU is fully used, it indicates 100%, but if multiple vCPUs are in use, the value could be above 100%.
Swap Usage (Bytes)	`SwapUsage`	The amount of swap used by the task.
Memory Usage (Bytes)	`MemoryUsage`	The control group (cgroup) `memory.usage_in_bytes` consumed by a task. DMS uses cgroups to control the usage of system resources such as memory and CPU. This metric indicates a task's memory usage in Megabytes within the cgroup allocated for that task. The cgroup limits are based on the resources available for your DMS replication instance class. `memory.usage_in_bytes` consists of resident set size (RSS), cache, and swap components of memory. The operating system can reclaim cache memory if needed. AWS DMS raises this metric against the combined dimensions of `ReplicationInstanceIdentifer` and `ReplicationTaskIdentifier` in the CloudWatch console. Use the `ReplicationInstanceIdentifier`, `ReplicationTaskIdentifier` category to view this metric.

Properties (Attributes)

Cisco Cloud Observability displays the following properties for AWS DMS.

Display Name	Property Name	Description
Replication Instance Name	`aws.dms.replication_instance.name`	The name of the replication instance.
ARN	`aws.dms.replication_instance.arn`	The Amazon Resource Name (ARN) of the replication instance.
Class	`aws.dms.replication_instance.class`	The compute and memory capacity of the replication instance as defined for the specified replication instance class.
Status	`aws.dms.replication_instance.status`	The status of the replication instance.
Allocated Storage	`aws.dms.replication_instance.allocated_storage`	The amount of storage (in gigabytes) that is allocated for the replication instance.
Created At	`aws.dms.replication_instance.create_time`	The time the replication instance was created.
Multi AZ	`cloud.network.id`	The identifier of the VPC.
VPC ID	`aws.dms.replication_instance.multi_az`	Specifies whether the replication instance is a Multi-AZ deployment. You can't set the AvailabilityZone parameter if the Multi-AZ parameter is set to true.
Engine Version	`aws.dms.replication_instance.engine_version`	The engine version number of the replication instance.
Automatic Minor Version Upgrade	`aws.dms.replication_instance.auto_minor_version_upgrade`	Boolean value indicating if minor version upgrades will be automatically applied to the instance.
Public IP Addresses	`aws.dms.replication_instance.public_ip_addresses`	Comma-separated list of public IP addresses for the replication instance.
Private IP Addresses	`aws.dms.replication_instance.private_ip_addresses`	Comma-separated list of private IP addresses for the replication instance.
Pending modify values - Instance Class	`aws.dms.replication_instance.pending_modified_values.class`	The compute and memory capacity of the replication instance as defined for the specified replication instance class.
Pending modify values - Storage	`aws.dms.replication_instance.pending_modified_values.allocated_storage`	The amount of storage (in gigabytes) that is allocated for the replication instance.
Pending modify values - Multi AZ	`aws.dms.replication_instance.pending_modified_values.multi_az`	Specifies whether the replication instance is a Multi-AZ deployment.
Pending modify values - Engine Version	`aws.dms.replication_instance.pending_modified_values.engine_version`	The engine version number of the replication instance.
Public	`aws.dms.replication_instance.publicly_accessible`	Specifies whether an instance is public or private.
Provider	`cloud.provider`	The name of the cloud provider.
Account ID	`cloud.account.id`	The cloud account ID the resource is assigned to.
Region	`cloud.region`	The cloud account ID the resource is assigned to.
Platform	`cloud.platform`	The cloud platform in use.
Availability Zone	`cloud.availability_zone`	The zone where the resource is running.

Display Name	Property Name	Description
Replication Task Name	`aws.dms.replication_task.name`	The name of the replication task.
Source ARN	`aws.dms.replication_task.source_endpoint_arn`	The ARN of the source database endpoint.
Target ARN	`aws.dms.replication_task.target_endpoint_arn`	The ARN of the target database endpoint.
ARN	`aws.dms.replication_task.arn`	The ARN of the replication task.
Replication Instance ARN	`aws.dms.replication_task.replication_instance_arn`	The ARN of the associated DMS replication instance.
Created At	`aws.dms.replication_task.creation_date`	The timestamp when the replication task was created.
Started At	`aws.dms.replication_task.start_date`	The date at which the replication start is scheduled to start.
Last Checkpoint	`aws.dms.replication_task.recovery_checkpoint`	Indicates the last checkpoint that occurred during a change data capture (CDC) operation.
Last Failure Message	`aws.dms.replication_task.last_failure_message`	The last error message encountered during task execution.
Migration Type	`aws.dms.replication_task.migration_type`	The type of database migration.
Stop Reason	`aws.dms.replication_task.stop_reason`	The reason the replication task was stopped.
Tables Loaded	`aws.dms.replication_task.tables.loaded`	The number of tables loaded for this task.
Tables Loading	`aws.dms.replication_task.tables.loading`	The number of tables currently loading for this task.
Tables Queued	`aws.dms.replication_task.tables.queued`	The number of tables queued for this task.
Tables Errored	`aws.dms.replication_task.tables.errored`	The number of errors during this task.
Provider	`cloud.provider`	The name of the cloud provider.
Account ID	`cloud.account.id`	The cloud account ID the resource is assigned to.
Region	`cloud.region`	The geographical region the resource is running.
Platform	`cloud.platform`	The cloud platform in use.
Availability Zone	`cloud.availability_zone`	Availability zone represents the zone where the resource is running.

Display Name	Property Name	Description
ARN	`aws.dms.endpoint.arn`	The ARN of the endpoint.
Type	`aws.dms.endpoint.type`	The type of endpoint.

Retention and Purge Time-To-Live (TTL)

For all cloud and infrastructure entities, the retention TTL is 180 minutes (3 hours) and the purge TTL is 525,600 minutes (365 days).

Amazon Web Services, the AWS logo, AWS, and any other AWS Marks used in these materials are trademarks of Amazon.com, Inc. or its affiliates in the United States and/or other countries.