SQL Server Integration Services ( SSIS ) Buffer Management

  • Article

SSIS Buffer Management
Data flow engine requires buffer to store incoming data from source, do the necessary transformation in-memory if any, and upload it in the destination. The creation, allocation and management of buffer are done by SSIS Buffer Manager.

I have written an article covering all aspects of SSIS buffer management, including how buffers are allocated and de-allocated for the transformation, different kind of buffer related performance counters etc.

Refer this link for more details.
https://www.sql-server-performance.com/articles/biz/SSIS_An_Inside_View_Part_3_p1.aspx