BI performance counter: Flat buffer memory

Applies to

SSIS

Description

Flat buffers refer to special chunk of memory that is usually used by the data flow transformation components such as the Aggregate transform.

This performance counter monitors the total number of these chunks of memory used by the Integration Services. The value of this performance counter is measured in bytes and fluctuates during package execution.

Resolved by

DBAs, Server administrators, ETL developers

Suggested solutions

  1. Optimize the SQL data source, lookup transformations, and destination
  2. SSIS is an in-memory pipeline, so ensure that all transformations occur in memory
  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