BI performance counter: Flat buffers in use

Applies to

SSIS

Description

This counter monitors the total number of chunks of memory currently being used by the data flow engine.

The value of this performance counter is measured in bytes and fluctuates during package execution. The value is reset whenever the service is restarted.

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