Linchi Shea : Batch Size, Multi-threadinghttp://sqlblog.com/blogs/linchi_shea/archive/tags/Batch+Size/Multi-threading/default.aspxTags: Batch Size, Multi-threadingenCommunityServer 2.1 SP2 (Build: 61129.1)Performance impact: What is the optimal payload for SqlBulkCopy.WriteToServer()?http://sqlblog.com/blogs/linchi_shea/archive/2011/07/01/performance-impact-what-is-the-optimal-payload-for-sqlbulkcopy-writetoserver.aspxFri, 01 Jul 2011 15:54:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:36574Linchi Shea4http://sqlblog.com/blogs/linchi_shea/comments/36574.aspxhttp://sqlblog.com/blogs/linchi_shea/commentrss.aspx?PostID=36574For many years, I have been using a C# program to generate the TPC-C compliant data for testing. The program relies on the SqlBulkCopy class to load the data generated as per the TPC-C specifications into the SQL Server tables. In general, the performance...(<a href="http://sqlblog.com/blogs/linchi_shea/archive/2011/07/01/performance-impact-what-is-the-optimal-payload-for-sqlbulkcopy-writetoserver.aspx">read more</a>)<img src="http://sqlblog.com/aggbug.aspx?PostID=36574" width="1" height="1">PerformanceData LoadBatch SizeMulti-threadingparallelismSqlBulkCopy