SSIS controls such as the Data Flow Task requires memory to temporary store buffers during package execution. This performance counter indicates the total amount of physical system memory allocated to the SSIS service process for package execution. Memory consumption by integration service can range from 2GB to 4GB depending on whether the service is running on 32-bit or 64-bit. This value is measured in bytes and is usually high. The value is reset back to zero whenever the SSIS service is restarted.
DBAs, Server administrators, ETL developers
- Add more memory
- Reduce the number of parallel SSIS package execution
- Consider running SSIS on a 64-bit machine
To track BI performance metrics – consider using ApexSQL BI Monitor, a web application that monitors system, SSAS, SSIS and SSRS performance in real time.