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. Performance Counters

Performance Tuning Guide

Performance Tuning Guide

Bottlenecks Overview

Bottlenecks Overview

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:
  1. Target
  2. Source
  3. Mapping
  4. Session
  5. System
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.