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

Monitoring Statistics

Monitoring Statistics

Monitoring is a domain function that the Service Manager performs. The Service Manager stores the monitoring configuration in the Model repository. Use the Monitor tab in the Administrator tool to monitor system bottlenecks such as the total number of running, failed, canceled, and completed jobs that run on a selected service.
Consider the following solution for monitoring statistics bottlenecks:
Configure the domain to set up monitoring.
When you set up monitoring, the Data Integration Service stores persisted statistics and monitoring reports in the Model repository. Persisted statistics are historical information about integration objects that previously ran. The monitoring reports show key metrics about an integration object.
Configure monitoring settings for the domain to specify the Model repository that stores the run-time statistics about objects deployed to Data Integration Services. Monitoring settings apply to all Data Integration Services that in the domain and can affect service performance.
The following table describes monitoring settings that can affect services performance:
Option
Description
Preserve Summary Historical Data
Number of days that the Model repository saves averaged data. If purging is disabled, then the Model repository saves the data indefinitely.
Default is 180. Minimum is 0. Maximum is 366.
Preserve Detailed Historical Data
Number of days that the Model repository saves per-minute data. If purging is disabled, then the Model repository saves the data indefinitely.
Default is 14. Minimum is 1. Maximum is 14.
Purge Statistics Every
Interval, in days, at which the Model Repository Service purges data that is older than the values configured in the
Preserve Historical Data
option.
Default is 1 day.
Days At
Time of day when the Model Repository Service purges statistics. Default is 1:00 a.m.
Maximum Number of Sortable Records
Maximum number of records that can be sorted in the
Monitor
tab. If the number of records on the
Monitor
tab is greater than this value, then you can only sort by
Start Time
and
End Time
. Default is 3,000.
Maximum Delay for Update Notifications
Maximum time, in seconds, that the Data Integration Service buffers statistics before it stores them in the Model repository and displays them in the
Monitor
tab. If the Data Integration Service shuts down unexpectedly before it stores the statistics in the Model repository, then the statistics are lost. Default is 10.
Show Milliseconds
Include milliseconds for date and time fields in the
Monitor
tab.

0 COMMENTS

We’d like to hear from you!