SSIS 2008 每批次行数和最大插入提交大小 [英] SSIS 2008 Rows per batch and Maximum insert commit size

问题描述

我通过数据流任务在 SSIS 2008 中移动了大约 1 亿行.它几乎是使用多播的直接表数据复制.我的问题是:

I've got about 100 million rows that I'm moving in SSIS 2008 via a Data Flow Task. It's pretty much a straight table data copy using a Multicast. My question is this:

使用 OLE DB 目标编辑器时，我有两个选项:每批行数和最大插入提交大小.什么是好的设置?我只能发现建议您将最大插入提交大小设置为 2147483647 而不是 0，然后根据测试调整这两个设置.我很想知道是否有人在他们自己管理这些价值观时发现了任何有用的东西.

Using the OLE DB Destination Editor I have two options: Rows per batch and Maximum insert commit size. What are good settings for this? I've only been able to find that you are recommended to set Maximum insert commit size to 2147483647 instead of 0, but then tweak both these settings based on testing. I'm curious to find out if anyone has discovered anything useful in their own management of these values.

推荐答案

没有最好的价值，它在很大程度上取决于数据库的设计、用户数量、您操作的硬件类型等.那是为什么你需要用你的系统亲自测试.

There is no best value, it depends greatly on the design of the database, the number of users, the kind of hardware you are operating one etc. THat is why you need to test for yourself with your system.

这篇关于SSIS 2008 每批次行数和最大插入提交大小的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！