DTS offers a wide range of performance metrics to help you easily view and monitor the status of data migration/synchronization instances. Data migration is used as an example to explain the performance metrics and how to view the performance monitoring information of instances.
Viewing Performance Monitoring Information
On the Instance List page, click the instance ID to go to the Instance Management page. On this page, click Instance Details in the upper-right corner to go to the details page. In the left-side navigation bar, choose Performance Monitoring > Full Data Migration Performance. Then, you can view the metrics of full data migration, including the migration traffic (BPS), migration performance (RPS), network latency, and SQL RT.
In the left-side navigation bar of the details page, click Incremental Data Migration Performance. Then, you can view the metrics of incremental data migration, including the migration traffic (BPS), migration performance (RPS), and network latency.
Performance Metric Description
| Performance Metric | Description |
|---|---|
| Full Data Migration Performance | (1) Full data migration traffic (MB/s) Read traffic: the amount of data that DTS reads from the source instance for migration. Unit: MB/s. Write traffic: the amount of traffic that DTS writes into the destination instance. Unit: MB/s. (2) Source instance RPS and destination instance RPS Source instance RPS: the number of data record changes per second, which are caused by add, update, and delete operations (DML operations, including INSERT, UPDATE, and DELETE) on the source database. Destination instance RPS: the number of data record changes per second, which are caused by add, update, and delete operations (DML operations, including INSERT, UPDATE, and DELETE) on the destination database. (3) Source database network latency and destination database network latency (ms) Source database network latency: the network latency between the source database and DTS. Destination database network latency: the network latency between the destination database and DTS. (4) Source database SQL RT and destination database SQL RT (ms) Source database SQL RT: the response time of the source database when DTS reads data from the source. Destination database SQL RT: the response time of the destination database when DTS writes data into the destination. |
| Incremental Data Migration Performance | You can view the monitoring information about incremental data migration, such as the migration traffic, migration performance, and network latency. The related performance metrics are described as follows: (1) Migration traffic (BPS): the amount of data written into the destination database per second. Unit: MB/s. (2) Migration performance (RPS): the number of rows that are written to the destination database per second. (3) Network latency: the network latency between the database and DTS. |