---
title: "Manage long-running transactions for AWS DMS performance"
url: https://daily.dev/posts/manage-long-running-transactions-for-aws-dms-performance-bdgogkizz
source_url: https://aws.amazon.com/blogs/database/manage-long-running-transactions-for-aws-dms-performance
type: article
source: "AWS Database Blog"
published: 2026-06-30T16:31:24.733Z
updated: 2026-06-30T16:33:10.530Z
tags: ["database", "change-data-capture"]
reading_time: 12
upvotes: 0
comments: 0
language: en
---

> ## Documentation Index
> Fetch the complete documentation index at: https://daily.dev/llms.txt
> Use this file to discover all available pages before exploring further.

# Manage long-running transactions for AWS DMS performance

**[AWS Database Blog](https://daily.dev/sources/aws-database-blog)** · 12 min read · 0 upvotes · 0 comments

## Summary

Long-running transactions are a common but overlooked cause of rising CDC source latency in AWS DMS migrations. When a transaction stays open, DMS must buffer all subsequent changes until it commits, causing latency to climb from seconds to hours. This post explains how DMS processes transactions, how to diagnose latency spikes, and provides ready-to-use bash monitoring scripts for Oracle, PostgreSQL, MySQL, and SQL Server. The scripts detect transactions exceeding a configurable threshold (default 15 minutes), send alerts via Amazon SNS, enforce TLS/SSL connections, retrieve credentials from AWS Secrets Manager, and filter false positives. A step-by-step Oracle demo shows the full workflow from DMS task setup to alert receipt. Scheduling via crontab enables continuous proactive monitoring.

## Full article

daily.dev links to this article rather than hosting it. Read it at the original source: <https://aws.amazon.com/blogs/database/manage-long-running-transactions-for-aws-dms-performance>

## Similar posts on daily.dev

- [Migrating mission-critical payments at Nubank to Amazon Aurora PostgreSQL](https://daily.dev/posts/migrating-mission-critical-payments-at-nubank-to-amazon-aurora-postgresql-uhkwmxh9s) · AWS Database Blog · 5 upvotes · 0 comments
- [Overcoming Oracle CDC Replication Lag Through Collaboration](https://daily.dev/posts/overcoming-oracle-cdc-replication-lag-through-collaboration-hscqvjtch) · Debezium · 4 upvotes · 0 comments

---

Tags: [#database](https://daily.dev/tags/database), [#change-data-capture](https://daily.dev/tags/change-data-capture)

[View this post on daily.dev](https://daily.dev/posts/manage-long-running-transactions-for-aws-dms-performance-bdgogkizz)