BI performance counter: Buffer memory

Applies to

SSIS

Description

This performance counter measures the total number of physical or virtual memory currently being used by all SSIS packages and can be compared with the amount of available system memory to know if Integration Services processing is bottlenecked by the available RAM. The recommended value for this counter is the one that is always less than the total available computer memory as this will indicate that data flow processing completes without spilling over to disk.

Resolved by

DBAs, Server administrators, ETL developers

Suggested solutions

  1. Make data types as narrow as possible so you will allocate less memory for your transformation
  2. Optimize the SQL data source, lookup transformations, and destination
  3. SSIS is an in-memory pipeline, so ensure that all transformations occur in memory
  4. Try to perform your data flows in bulk mode instead of row by row

Additional research

SSIS Pipeline performance counters
SSIS: Performance Counter
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