Table of Contents

Search

  1. Preface
  2. Performance Tuning Overview
  3. Target Optimization
  4. Source Optimization
  5. Transformation Optimization
  6. Mapping Optimization
  7. Partitioned Mapping Optimization
  8. Run-time Optimization
  9. SQL Data Service Optimization
  10. Web Service Optimization
  11. Connections Optimization
  12. Data Transformation Optimization

Performance Tuning Guide

Performance Tuning Guide

Database Checkpoint Intervals

Database Checkpoint Intervals

The Data Integration Service performance slows each time it waits for the database to perform a checkpoint.
Consider the following solution to reduce database checkpoint bottlenecks:
Increase the checkpoint interval in the database.
To decrease the number of checkpoints and increase performance, increase the checkpoint interval in the database.
Although you gain performance when you reduce the number of checkpoints, you also increase the recovery time if the database shuts down unexpectedly.

0 COMMENTS

We’d like to hear from you!