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.
DBAs, Server administrators
- 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