All Products
Search

This Product

    Data Transmission Service:View hot spot table information

    Document Center

    Data Transmission Service:View hot spot table information

    Last Updated:Mar 30, 2026

    When a hotspot table — a table with a very high rate of incremental data changes — exists in your DTS task, synchronization or migration latency can exceed 1,000 milliseconds. Use the Hotspot Table Information panel to identify whether a hotspot table is causing the latency, then enable hot data merging if needed.

    Prerequisites

    Before you begin, make sure that:

    • A data synchronization or migration instance is purchased and configured

    • (Migration only) Incremental Data Migration is selected as the migration type

    View hotspot table information

    The steps for viewing hot data are the same for data synchronization and data migration instances. The following steps use a data synchronization instance as an example.

    1. Go to the Data Synchronization page using one of the following methods.

      DTS console

      1. Log on to the DTS console.

      2. In the left-side navigation pane, click Data Synchronization.

      3. In the upper-left corner of the page, select the region where your instance resides.

      DMS console

      The actual steps may differ based on the mode and layout of the DMS console. For details, see Simple mode and Customize the layout and style of the DMS console.

      1. Log on to the DMS console.

      2. In the top navigation bar, move the pointer over Data + AI and choose DTS (DTS) > Data Synchronization.

      3. From the drop-down list to the right of Data Synchronization Tasks, select the region where your instance resides.

    2. Click the ID of your DTS instance.

    3. (Optional) In the left-side pane, click Task Management.

    4. In the Progress section, click the Incremental Write module.

    5. On the Basic Information tab, view the Hotspot Table Information parameter.

    The panel shows the table with the most frequent data changes in the destination database:

    • If the destination database has ongoing incremental changes, the panel shows the current hotspot table.

    • If the destination database has no ongoing changes, the panel shows the most recent hotspot table.

    The Hotspot Table Information panel updates only after incremental data from the source tables is written to the destination tables and the consumption checkpoint is updated.

    The panel includes the following fields:

    Field Description
    Database name The database that contains the hotspot data.
    Table name The table that contains the hotspot data.
    Conflicting key The primary key or unique key value of the hotspot data.
    Conflict level The number of incremental data changes. The value is greater than or equal to 1. If the value is greater than 10, we recommend that you enable the hot data merging feature to reduce latency.

    Enable hot data merging

    If Conflict level is greater than 10, enable the trans.hot.merge.enable parameter.

    1. In the Progress section, click the Incremental Write module, then click the Parameter Settings tab.

    2. Find the trans.hot.merge.enable parameter and click the Edit icon in the Parameter Value column.

    3. In the Modify Parameters dialog box, set the parameter value to true. Modify Parameter dialog box

    4. Click OK.

      The Parameter Value column now shows true (Not yet take effect). The change is not active until you apply it in the next step.

    5. Click Submit Parameters.

    6. In the Apply Changes dialog box, click OK. Submit Parameters dialog box

      Take Effect Immediately is selected by default, so the change takes effect as soon as you click OK.

    7. Click Refresh above the Incremental Write module to refresh the status.

    Hot data merging is active when the Incremental Write module shows Running and the trans.hot.merge.enable parameter value is true without (Not yet take effect).