Hi, I'm Ask INFA!
What would you like to know?
ASK INFAPreview
Please to access Ask INFA.

Table of Contents

Search

  1. Preface
  2. Data Integration performance tuning overview
  3. Optimizing targets
  4. Optimizing sources
  5. Optimizing mappings
  6. Optimizing mapping tasks
  7. Optimizing advanced clusters
  8. Optimizing system performance

Data Integration Performance Tuning

Data Integration Performance Tuning

Identifying system bottlenecks on Windows

Identifying system bottlenecks on Windows

You can view the
Performance and Processes
tab in the Task Manager for system information. The
Performance
tab in the Task Manager provides an overview of CPU usage and total memory used.
Use the Performance Monitor to view more detailed information. The following table describes the system information that you can use in the Windows Performance Monitor to create a chart:
Property
Description
Percent processor time
If you have more than one CPU, monitor each CPU for percent processor time.
Pages/second
If pages/second is greater than five, you may have excessive memory pressure known as thrashing.
Physical disks percent time
The percent of time that the physical disk is busy performing read or write requests.
Physical disks queue length
The number of users waiting for access to the same disk device.
Server total bytes per second
The server has sent to and received from the network.

0 COMMENTS

We’d like to hear from you!