Applies to
SSIS
Description
This performance counter monitors the total number of physical and virtual memory currently being used by data flow engine’s transformation tasks.
The value for this counter is measured in bytes which can be high or low depending on the amount of transformation required in the given data flow engine.
Resolved by
DBAs, Server administrators
Suggested solutions
- Add more physical memory to the computer
- Make data types as narrow as possible so you will allocate less memory for your transformation
- If possible, perform your date-time conversions at your source or target databases, as it is more expensive to perform within Integration Services.
- 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