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

Increasing DTM Buffer Size

Increasing DTM Buffer Size

The DTM Buffer Size setting specifies the amount of memory that the Integration Service uses as DTM buffer memory. When you increase the DTM buffer memory, the Integration Service creates more buffer blocks, which improves performance during momentary slowdowns.
Increasing DTM buffer memory allocation generally causes performance to improve initially and then level off. If you do not see a significant increase in performance, DTM buffer memory allocation is not a factor in session performance.
To increase the DTM buffer size, open the session properties and click the Properties tab. Edit the DTM Buffer Size property in the Performance settings. Increase the DTM Buffer Size property by multiples of the buffer block size.

0 COMMENTS

We’d like to hear from you!