All Products
Search
Document Center

Data Transmission Service:View incremental data migration status and performance

Last Updated:Jun 20, 2026

Data Transmission Service (DTS) provides performance monitoring and diagnostic features to track the status of your incremental data migration tasks. You can view key metrics such as link status, the number of DDL operations, slow SQL queries, Bandwidth, migration performance, and migration latency. These insights, along with the Diagnostics feature, help you manage your migration tasks.

Procedure

  1. Log on to the DTS console.

    Note

    If you are automatically redirected to the Data Management (DMS) console, you can click the jiqiren icon in the lower-right corner and then click 返回旧版 to return to the classic DTS console.

  2. In the left-side navigation pane, click Data Migration.
  3. At the top of the Migration tasks page, select the region where your task is located.
  4. On the Migration tasks page, click the ID of the destination database.
  5. In the left-side navigation pane, choose Performance Monitoring > Performance of Incremental Data Migration.
  6. This page displays the DTS link topology and diagnostic information. You can also select a time range to view trend charts for various performance metrics.
    Feature Description
    Incremental migration link topology The topology shows the data transmission status and network latency between modules. The modules include the source database, DTS collection module, DTS caching module, DTS writing module, and destination database. The parameters are defined as follows:
    • BPS: The amount of data transmitted between modules, in MB/s.
    • RPS: The number of rows transmitted between modules per second.
    • Network Latency: The network latency between modules.
    Diagnostics This feature checks the performance of the source database, destination database, network, and DTS during incremental migration and provides diagnostic results and recommendations. To use this feature:
    1. In the upper-right corner of the page, click Quick Diagnostics.
    2. In the dialog box that appears, click Confirm.
    3. Refresh the page to view the diagnostic progress. To view detailed information, click the 展开详细诊断信息 icon.
    Performance of incremental data migration You can view metrics such as Bandwidth, migration performance, and migration latency. Click the More Metrics drop-down list to display additional performance metrics, such as Number of DDL operations, Latency (ms), and Slow SQL queries.

    The metrics are defined as follows:

    • Bandwidth: The amount of data written to the destination database, in MB/s.
    • Migration performance (RPS): The number of rows written to the destination database per second.
    • Migration latency (s): The time difference between the current time on the source database and the timestamp of the last record written to the destination database.
    • Executed DDL Operations: The number of DDL operations executed on the destination database within the selected time range.
    • Task Latency (ms): The time difference between when a data record is created in the source database and when it is written to the destination database. For example, if a data record is created in the source database at 7:00 and DTS writes the record to the destination database at 8:00, the latency is one hour.
    • Slow SQL Queries: The number of slow SQL queries occurring in the destination database within the selected time range.