After you identify system bottlenecks, tune the system to remove the bottlenecks and improve performance.
Complete the following tasks to eliminate system bottlenecks:
•If the CPU usage is more than 80%, check the number of concurrent running tasks. Consider changing the load or using a Secure Agent group to distribute tasks to different agent machines. If you can't reduce the load, consider adding more processors.
•If swapping occurs, increase the physical memory, or reduce the number of memory-intensive applications on the disk.
•If you have excessive memory pressure (thrashing), consider adding more physical memory.
•If the percent of time is high, tune the cache for transformations to use in-memory cache instead of writing to disk. If you tune the cache, requests are still in queue, and the disk busy percentage is at least 50%, upgrade to a faster disk. If physical disk queue length is greater than two, consider upgrading the disk.
•If the percent time spent waiting on I/O is high, consider upgrading to a faster disk or using other under-utilized disks. For example, if the source data, target data, lookup, rank, and aggregate cache files are all on the same disk, consider putting them on different disks.