BI performance counter: Private buffers in use

Applies to

SSIS

Description

This performance counter monitors the total number of physical and virtual memory currently being used by 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. Make data types as narrow as possible so you will allocate less memory for your transformation
  3. If possible, perform your date-time conversions at your source or target databases, as it is more expensive to perform within Integration Services.
  4. 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