Applies to

SSIS

Description

This performance counter monitors the total number of bytes within the data flow engine that are written out as binary large object (BLOB) into all target data sources. This is usually represented as a high bytes value which is reset back to zero bytes whenever the Integration Service server is restarted. This counter may indicate a need for additional RAM and temporary storage.

Resolved by

DBAs, Server administrators, ETL developers

Suggested solutions

1. Use dm_execution_performance_counters function to retrieve statistics for a running execution
2. Add more physical memory to the computer
3. Reduce extracting BLOB data such as images in your data flow

Additional research

Something about SSIS Performance Counters
SSIS Pipeline performance counters guide
Introduction to BLOB data types in SSIS: Part 1

⇐ Back to index