BI performance counter: Private buffer memory

Applies to

SSIS

Description

A transformation task such as the Sort transform may require additional physical or virtual memory at runtime. In such cases, the data flow engine will generate a private buffer required by the given data transformation.

This performance counter monitors the total number of physical and virtual memory created at runtime by the data flow engine’s transformation tasks. The value for this counter is measured in bytes which can be high or low depending on the amount of transformation required in the given data flow engine.

Resolved by

DBAs, Server administrators

Suggested solutions

  1. Add more physical memory to the computer
  2. Do not sort within Integration Services unless it is absolutely necessary
  3. Try to perform your data flows in bulk mode instead of row by row

Additional research

SSIS Performance Tuning-Monitoring & Data Collection
Something about SSIS Performance Counters
Perfmon Counters for the Integration Services Data Flow Engine

 

To track BI performance metrics – consider using ApexSQL BI Monitor, a web application that monitors system, SSAS, SSIS and SSRS performance in real time.

⇐ Back to index