If a session contains Aggregator, Rank, or Joiner transformations, examine the

Transformation_

readfromcache and

Transformation

_writetocache counters along with the

Transformation_

readfromdisk and

Transformation

_writetodisk counters to analyze how the Integration Service reads from or writes to disk. To view the session performance details while the session runs, right-click the session in the Workflow Monitor and choose Properties. Click the Properties tab in the details dialog box.

To analyze the disk access, first calculate the hit or miss ratio. The hit ratio indicates the number of read or write operations the Integration Service performs on the cache.

The miss ratio indicates the number of read or write operations the Integration Service performs on the disk.

Use the following formula to calculate the cache miss ratio:

Use the following formula to calculate the cache hit ratio:

To minimize reads and writes to disk, increase the cache size. The optimal cache hit ratio is 1.