BI performance counter: BLOB bytes read

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

  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

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

 

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