SSIS中的默认缓冲区最大大小和默认缓冲区大小 [英] Default Buffer Max Size and Default Buffer Size in SSIS

问题描述

SSIS中的默认缓冲区最大"行和默认缓冲区大小"之间是否存在任何关系. 如何为这些属性参数提供值?

Is there any relationship between Default Buffer Max rows and Default Buffer Size in SSIS. How to supply values to these property parameters?

我的意思是这两者之间是否有特殊性?如果我将缓冲区大小加倍，那么我是否还必须使最大行数加倍? SSIS专家请回答.

I mean is there any propossionality in between these ?If I double the buffer size double then can i also have to make the max rows to double? ssis experts please answer..

Oledb源包含2000万条记录以及查找表.我已经设计了具有上述buffersize和buffer行的数据流.

Here the Oledb source contain 20 million records ,and also the lookup table.I have designed the dataflow with the mentioned buffersize and buffer rows.

这是在数据流任务下为所有组件设置的最大大小吗? 还是看起来一旦完成查找便释放下一个组件的缓冲区?

Is this the maximum size set up for all the components under the dataflow task? or is it like once the Lookup completes then it releases the buffer for the next component?

我将缓冲区和最大行数增加了一倍，但没有发现任何性能提升.

I have doubled the size of buffer and the maxrows,but could not find any performance gain.

推荐答案

缓冲区大小可根据sis中所需的内存进行自定义. ssis使用的最大内存为100 MB.我要做的是在OLEDB目标中定义表"或视图"-快速加载"或表名或视图名称"变量-快速加载"以增加负载.

The buffer size is customizable based on memory needed in ssis. The max memory that ssis use is 100 MB. What I would do extra is in OLEDB destination I would define Table or view -Fast load or table name or view name variable -Fast load to boost the load.

来自 James Serrra的博客的链接

这篇关于SSIS中的默认缓冲区最大大小和默认缓冲区大小的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！