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

Using the 64-bit Version of PowerCenter

Using the 64-bit Version of PowerCenter

If you process large volumes of data or perform memory-intensive transformations, you can use the 64-bit PowerCenter version to increase session performance. The 64-bit version provides a larger memory space that can significantly reduce or eliminate disk input/output.
This can improve session performance in the following areas:
  • Caching.
    With a 64-bit platform, the Integration Service is not limited to the 2 GB cache limit of a 32-bit platform.
  • Data throughput.
    With a larger available memory space, the reader, writer, and DTM threads can process larger blocks of data.