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

Web Service Property to Configure an Active DTM Instance

Web Service Property to Configure an Active DTM Instance

To increase performance, you can configure the Data Integration Service to keep a DTM instance active so that it can process more than one web service request. You can configure the DTM Keep Alive Time property for the Data Integration Service in the Administrator tool.
The following table describes the DTM Keep Alive Time property:
Property
Description
DTM Keep Alive Time
Number of milliseconds that the DTM instance stays open after it completes the last request. Web service requests that are issued against the same operation can reuse the open instance. Use the keep alive time to increase performance when the time required to process the request is small compared to the initialization time for the DTM instance. If the request fails, the DTM instance terminates.
Default is 5000.
The ability to use an existing DTM instance increases performance. The DIS requires additional resources to start a DTM instance for each request. Keeping the DTM active consumes memory. Therefore, users should consider the memory consumption when configuring this option.

0 COMMENTS

We’d like to hear from you!