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

Model Repository Service Optimization

Model Repository Service Optimization

Tune the Model Repository Service to improve performance. You can configure the Model Repository Service process property for memory and minimize network latency.
Consider the following solutions for Model Repository Service bottlenecks:
Host the Model repository database on the same machine as the Model Repository Service.
The Model Repository service process performance can be affected if the Model repository database is hosted on a remote server. Model Repository Service operations that require communication between the Model repository and the Model Repository Service on a high-latency network could slow down the Model Repository Service performance.
Increase the Maximum Heap Size property for the Model Repository Service process.
The Model Repository 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 Model Repository Service and other services such as the Data Integration Service or the Analyst Service.
Use the Administrator tool to configure the Maximum Heap Size property to a larger value in the Advanced Properties for the Model Repository Service process.

0 COMMENTS

We’d like to hear from you!