Browse by Tags

• Batch Size
• Disk I/O
• Multi-threading
• parallelism
• Performance
• Query Processing
• space allocation
• SqlBulkCopy
• Storage
• Testing

• Performance impact: SqlBulkCopy.WriteToServer() and interesting space allocation behavior

  After reading Adam Machanic’s comment to my previous post , I started to wonder if what I saw was all due to the fact that SQL Server blindly chooses to allocate at least one extent in response to each call to WriteToServer(), perhaps in its zeal to achieve Read More... Posted Monday, July 04, 2011 11:35 PM by Linchi Shea | 2 Comments Filed under: Performance, Data Load, SqlBulkCopy, space allocation

• Performance impact: What is the optimal payload for SqlBulkCopy.WriteToServer()?

  For 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 Read More... Posted Friday, July 01, 2011 12:54 PM by Linchi Shea | 4 Comments Filed under: Performance, Data Load, Batch Size, Multi-threading, parallelism, SqlBulkCopy

• T-SQL Exercise: Simplest data-loading script to produce worst query performance – May 29th Update

  This is another follow-up on the T-SQL exercise . So the test query below is rather simple: DBCC DROPCLEANBUFFERS go SELECT COUNT(*) FROM dbo.test; But beneath its simple appearance, many factors are at play and interact in a complex way to influence Read More... Posted Friday, May 29, 2009 1:23 PM by Linchi Shea | 2 Comments Filed under: Performance, Testing, Storage, Query Processing, Disk I/O, Data Load