Applies to
SSIS
Description
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.
Resolved by
DBAs, Server administrators, ETL developers
Suggested solutions
- 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
Additional research
Performance Counters
SSIS Pipeline performance counters guide
Introduction to BLOB data types in SSIS: Part 1