Subscribe to this blog
SQLRunner
This blog is syndicated from SSIS - SQL Server Tidbits(http://josef-richberg.squarespace.com)
Archives: April 2012
SSIS Data Flow Tuning
During my SSWUG webcast I was asked to give some examples on how to tune the DefaultBufferMaxRows and DefaultBufferSize, so here goes.
When a source is pulling in data, it places them into buffers; one row=one buffer. The default setting for DefaultBufferMaxRows=10,000. This means that the source will… Read more
0 comments, 901 reads
Posted in SQLRunner on 27 April 2012