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.
DBAs, Server administrators, ETL developers
- Optimize the SQL data source, lookup transformations, and destination
- SSIS is an in-memory pipeline, so ensure that all transformations occur in memory
- Try to perform your data flows in bulk mode instead of row by row