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.
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