We Loaded 1TB in 30 Minutes with SSIS, and So Can You
SQL Server Technical Article
Writers: Len Wyatt, Tim Shea, David Powell
Published: March 2009
In February 2008, Microsoft announced a record-breaking data load using Microsoft SQL Server Integration Services (SSIS): 1 TB of data in less than 30 minutes. That data load, using SQL Server Integration Services, was 30% faster than the previous best time using a commercial ETL tool. This paper outlines what it took: the software, hardware, and configuration used. We will describe what we did to achieve that result, and offer suggestions for how to relate these techniques to typical scenarios. Even for customers who don’t have needs quite like this benchmark, such efforts can teach a lot about getting optimal performance.
Abstract courtesy Microsoft
Reference : Pinal Dave (https://blog.sqlauthority.com)
2 Comments. Leave new
Thanks for sharing the white paper, the hadware is really amazing especially the destination server. I guess with respect to SSIS performance tuning, i am learning that it is essential to know the software and hardware aspects.
Hi Pinal Dave….. I am a big fan of yours….this website is really amazing and the work u hav done is outstanding…thanks for all u r support …….I have one request to u ….if you have faced any problems in real time scenario and later on u have resolved those issues similar to the above white paper can u plz share with us …. thanks heaps
Azeem
Aust