About performance tuning

For instance, the amount of available memory, disk space, CPU resources, and the capabilities of your source and target database will have an impact on the performance of CDC Replication. For this reason, many performance tuning topics in this documentation are focused on tuning the environment to improve CDC Replication performance. The topics in this documentation will help you to utilize the full capabilities of CDC Replication and give you the tools you need to scale CDC Replication for the workload in your database.

This documentation contains information on the following:

• Overview of the Management Console Performance view as the primary tool that allows you to diagnose the performance of a subscription, or tables within a subscription, by selecting metrics by which to gauge performance. The workflow for using this tool is also discussed extensively.
• Environment and configuration issues that may affect the performance of CDC Replication. All too often, the environment in which CDC Replication is deployed will affect performance.

In general, performance tuning should always be aimed at meeting the business requirements for a particular environment. For example, high latency may be acceptable in an overnight batch run as long as CDC Replication replication has caught up by the next day of business. Performance tuning in this scenario is not necessary if the current level of latency meets your business needs.