The first step in performance tuning is to identify performance bottlenecks. Performance bottlenecks can occur in the source and target databases, the mapping, the session, and the system. The strategy is to identify a performance bottleneck, eliminate it, and then identify the next performance bottleneck until you are satisfied with the performance.
Look for performance bottlenecks in the following order:
Use the following methods to identify performance bottlenecks:
Run test sessions.
You can configure a test session to read from a flat file source or to write to a flat file target to identify source and target bottlenecks.
Analyze performance details.
Analyze performance details, such as performance counters, to determine where session performance decreases.
Analyze thread statistics.
Analyze thread statistics to determine the optimal number of partition points.
Monitor system performance.
You can use system monitoring tools to view the percentage of CPU use, I/O waits, and paging to identify system bottlenecks. You can also use the Workflow Monitor to view system resource usage.