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

Improving Network Speed

Improving Network Speed

The performance of the Integration Service is related to network connections. A local disk can move data 5 to 20 times faster than a network. Consider the following options to minimize network activity and to improve Integration Service performance.
If you use flat file as a source or target in a session and the Integration Service runs on a single node, store the files on the same machine as the Integration Service to improve performance. When you store flat files on a machine other than the Integration Service, session performance becomes dependent on the performance of the network connections. Moving the files onto the Integration Service process system and adding disk space might improve performance.
If you use relational source or target databases, try to minimize the number of network hops between the source and target databases and the Integration Service process. Moving the target database onto a server system might improve Integration Service performance.
When you run sessions that contain multiple partitions, have the network administrator analyze the network and make sure it has enough bandwidth to handle the data moving across the network from all partitions.