Performance Impact: Finding the Most Optimal Batch Sizehttp://sqlblog.com/blogs/linchi_shea/archive/2007/08/23/performance-impact-finding-the-most-optimal-batch-size.aspxIn my previous posts ( 1 , 2 , 3 ), I focused on the performance behavior of setting the checkpoints and transaction commit sizes to once every 16 inserts and once every 100,000 inserts. A question remains: what is the most optimal size? In other words,enCommunityServer 2.1 SP2 (Build: 61129.1)Performance Impact: the Most Optimal Insert Script can't Beat BulkCopyhttp://sqlblog.com/blogs/linchi_shea/archive/2007/08/23/performance-impact-finding-the-most-optimal-batch-size.aspx#2366Mon, 27 Aug 2007 15:05:44 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:2366Linchi Shea<p>With the insert script and the test configurations in my previous posts , the best data load throughput</p>