Some of the biggest transactions in SSIS takes place in the data flow tasks involving the data flow engine. This performance counter monitors the total number of bytes of binary large object (BLOB) data the data flow engine has read from all data sources. The BLOB data not only refer to data flow source adapters but to the Import and Export column transformations. The value representing this counter is measured in bytes and it is usually high but can be reset back to zero whenever the Integration Service server is restarted.
DBAs, Server administrators, ETL developers
- Use dm_execution_performance_counters function to retrieve statistics for a running execution
- Add more physical memory to the computer
- Reduce extracting BLOB data such as images in your data flow