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

Performance Tuning Guide

Performance Tuning Guide

Analyst Service Optimization

Analyst Service Optimization

Tune the Analyst Service to optimize performance. You can configure the Analyst Service process property for memory, minimize network latency, and configure the Analyst tool flat file upload settings to improve service performance.
Consider the following solutions for Analyst Service bottlenecks:
Configure the Analyst tool to connect to a network path location to upload flat files greater than 10 MB.
The Analyst Service process performance can decrease when analysts upload flat files greater than 10 MB to the Informatica Installation directory on the machine on which the Analyst tool runs. This can affect both disk space and network performance.
Upload flat files smaller than 10 MB to the Informatica Installation directory from the Analyst tool.
The Analyst Service process performance can decrease if analysts upload flat files greater than 10 MB to the Informatica Installation directory from the Analyst tool. This can affect both disk space and network performance.
Increase the Maximum Heap Size property for the Analyst Service process.
The Analyst Service process can consume large amounts of memory while processing a large number of concurrently logged in users. This can cause a large number of network connections to be open between the Analyst Service and other services such as the Data Integration Service or the Model Repository Service.
Use the Administrator tool to configure the Maximum Heap Size property to a larger value in the Advanced Properties for the Analyst Service process.
Export large mapping specifications to a table or export to a flat file and truncate the file.
The Analyst Service process can have a performance impact when analysts export large mapping specifications as flat files from the Analyst tool.

0 COMMENTS

We’d like to hear from you!