Applies to
SSIS
Description
A transformation task such as the Sort transform may require additional physical or virtual memory at runtime. In such cases, the data flow engine will generate a private buffer required by the given data transformation.
This performance counter monitors the total number of physical and virtual memory created at runtime by the 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
- Do not sort within Integration Services unless it is absolutely necessary
- 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