Home » Performance Tuning

Performance Tuning – Aggregator Transformations

Aggregator transformations often slow performance because they must group data before processing it. Aggregator transformations need additional memory to hold intermediate group results. Use the following guidelines to optimize the performance of an Aggregator transformation: Group by simple…

Read More »

Performance Tuning – Target Bottlenecks

The most common performance bottleneck occurs when the Integration Service writes to a target database. Small checkpoint intervals, small database network packet sizes, or problems during heavy loading operations can cause target bottlenecks. How to identify a Target Bottlenecks?…

Read More »