Performance Tuning Guide

Back Next

System Optimization

Consider the following solutions for system optimization bottlenecks:

Improve network speed.: Slow network connections can slow mapping performance. Have the system administrator determine if the network runs at an optimal speed. Decrease the number of network hops between the Data Integration Service process and databases.
Use multiple CPUs.: You can use multiple CPUs to run multiple mappings in parallel.
Reduce paging.: When an operating system runs out of physical memory, it starts paging to disk to free physical memory. Configure the physical memory for the Data Integration Service process machine to minimize paging to disk.
Use processor binding.: In a multi-processor UNIX environment, the Data Integration Service may use a large amount of system resources. Use processor binding to control processor usage by the Integration Service process. Also, if the source and target database are on the same machine, use processor binding to limit the resources used by the database.