BI performance counter: Working Set

Applies to



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.

Resolved by

DBAs, Server administrators, ETL developers

Suggested solutions

  1. Add more memory
  2. Reduce the number of parallel SSIS package execution
  3. Consider running SSIS on a 64-bit machine

Additional research

SSIS Service performance counter guide
Top 10 SQL Server Integration Services Best Practices
Quick perfmon check to detect potential memory leak in Windows


To track BI performance metrics – consider using ApexSQL BI Monitor, a web application that monitors system, SSAS, SSIS and SSRS performance in real time.

⇐ Back to index