Table of Contents

Search

  1. Preface
  2. Performance Tuning Overview
  3. Bottlenecks
  4. Optimizing the Target
  5. Optimizing the Source
  6. Optimizing Mappings
  7. Optimizing Transformations
  8. Optimizing Sessions
  9. Optimizing Grid Deployments
  10. Optimizing the PowerCenter Components
  11. Optimizing the System
  12. Using Pipeline Partitions
  13. Appendix A: Performance Counters

Performance Tuning Guide

Performance Tuning Guide

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.