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

Using a Machine with More Memory

Using a Machine with More Memory

To increase session performance, run the session on an Integration Service node with a large amount of memory. Increase the index and data cache sizes as high as you can without straining the machine. If the Integration Service node has enough memory, increase the cache so it can hold all data in memory without paging to disk.