Table of Contents

Search

  1. Preface
  2. Performance Tuning Overview
  3. Bottlenecks
  4. Optimizing the Target
  5. Optimizing the Source
  6. Optimizing Mappings
  7. Optimizing Transformations
  8. Optimizing Sessions
  9. Optimizing Grid Deployments
  10. Optimizing the PowerCenter Components
  11. Optimizing the System
  12. Using Pipeline Partitions
  13. Appendix A: Performance Counters

Performance Tuning Guide

Performance Tuning Guide

Performance Tuning Overview

Performance Tuning Overview

The goal of performance tuning is to optimize session performance by eliminating performance bottlenecks. To tune session performance, first identify a performance bottleneck, eliminate it, and then identify the next performance bottleneck until you are satisfied with the session performance. You can use the test load option to run sessions when you tune session performance.
If you tune all the bottlenecks, you can further optimize session performance by increasing the number of pipeline partitions in the session. Adding partitions can improve performance by utilizing more of the system hardware while processing the session.
Because determining the best way to improve performance can be complex, change one variable at a time, and time the session both before and after the change. If session performance does not improve, you might want to return to the original configuration.
Complete the following tasks to improve session performance:
  1. Optimize the target.
    Enables the Integration Service to write to the targets efficiently.
  2. Optimize the source.
    Enables the Integration Service to read source data efficiently.
  3. Optimize the mapping.
    Enables the Integration Service to transform and move data efficiently.
  4. Optimize the transformation.
    Enables the Integration Service to process transformations in a mapping efficiently.
  5. Optimize the session.
    Enables the Integration Service to run the session more quickly.
  6. Optimize the grid deployments.
    Enables the Integration Service to run on a grid with optimal performance.
  7. Optimize the PowerCenter components.
    Enables the Integration Service and Repository Service to function optimally.
  8. Optimize the system.
    Enables PowerCenter service processes to run more quickly.