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

Performance Tuning Guide

Performance Tuning Guide

Tuning the Database

Tuning the Database

If the database is not tuned properly, the results may not make the session any quicker. You can test the database to ensure it is tuned properly.
To verify that the database is tuned properly:
  1. Create a pipeline with one partition.
  2. Measure the reader throughput in the Workflow Monitor.
  3. Add the partitions.
  4. Verify that the throughput scales linearly.
    For example, if the session has two partitions, the reader throughput should be twice as fast. If the throughput does not scale linearly, you probably need to tune the database.