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.
DBAs, Server administrators, ETL developers
- Make data types as narrow as possible so you will allocate less memory for your transformation
- 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