SQLAuthority News – Interesting Whitepaper – We Loaded 1TB in 30 Minutes with SSIS, and So Can You

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.

Read the white paper here.

Abstract courtesy Microsoft

Reference : Pinal Dave (https://blog.sqlauthority.com)

Business Intelligence, SQL White Papers, SSIS
Previous Post
SQLAuthority News – SQL Server 2008 R2 Update for Developers Training Kit (March 2010 Update)
Next Post
SQL SERVER – MAXDOP Settings to Limit Query to Run on Specific CPU

Related Posts

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.

    Reply
  • 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

    Reply

Leave a Reply