Bit of a debate going on regarding these 2 values.
My understanding of this has been that SSIS will look at these 2 values and then makes an analysis of the dataflow to determine how the average size of a row in the dataflow ad how many rows it can fit within the 10MB (if you leave the default). The question arises on what happens when your rowsize will allow you to have more than 10000 rows in the buffer. If you leave it at the default this is the most rows it will put in a buffer, but does it still allocate the full 10MB to that buffer.
Example:
Col1 Varchar(25)
Col2 int
Col3 int
Col4 bigint
Col5 datetime
This gives me a max row size of 49 bytes allowing for a possible 213995 rows to fit within the default buffer size. With the max rows being 10K it needs to build 21 buffers. The question is Are each of these buffers 10MB meaning that I am now using 210MB when I could use 10MB.
Everything I have read and the way I understand it is that Yes 10MB is allocated to each buffer Even if it is partially full.
Paul
---------------------------------------
Shoot Me! Shoot Me NOW!!!
- Daffy Duck
My understanding of this has been that SSIS will look at these 2 values and then makes an analysis of the dataflow to determine how the average size of a row in the dataflow ad how many rows it can fit within the 10MB (if you leave the default). The question arises on what happens when your rowsize will allow you to have more than 10000 rows in the buffer. If you leave it at the default this is the most rows it will put in a buffer, but does it still allocate the full 10MB to that buffer.
Example:
Col1 Varchar(25)
Col2 int
Col3 int
Col4 bigint
Col5 datetime
This gives me a max row size of 49 bytes allowing for a possible 213995 rows to fit within the default buffer size. With the max rows being 10K it needs to build 21 buffers. The question is Are each of these buffers 10MB meaning that I am now using 210MB when I could use 10MB.
Everything I have read and the way I understand it is that Yes 10MB is allocated to each buffer Even if it is partially full.
Paul
---------------------------------------
Shoot Me! Shoot Me NOW!!!
- Daffy Duck