This topic provides reference performance data for replication workloads in data synchronization mode.
The performance data provided in this document should only be used for reference when you plan the capacity of your replication workloads. The data in this document are not guaranteed performance levels and the actual performance of your synchronization tasks may differ from the data provided. For performance levels guaranteed by DTS, see the Service Level Agreement (SLA).
Data synchronization performance data
|Instance size||Maximum performance (RPS)|
|micro||Less than 200|
|small||200 to 2,000|
|medium||2,000 to 5,000|
Note The actual replication performance depends on the network latency and the performance of the source and target database systems.
Note The performance of each instance type is measured in replications per second (RPS). This measurement represents the number of SQL statements that are replicated per second, including BEGIN operation, COMMIT operation, DML statements (INSERT, UPDATE, and DELETE operations), and DDL statements. The performance data listed in this document were obtained from performance tests that were run in a setup that meets the following conditions:
- The stress test that runs on the source instance produces a workload that exceeds the maximum performance of each DTS instance size.
- The target database instance can deliver sufficient performance to handle the write workloads generated by the replication task.
- The network latency between the DTS server and the source or target instance is less than or equal to 2 milliseconds.