SSIS 2008 - world record ETL performance

SSIS 2008 - world record ETL performance

  • Comments 7

Using SQL Server 2008 and SSIS 2008 the SQL Server Performance team working with Unisys and SQL CAT have shown SSIS scaling to world record performance!  We loaded 1.18 TB in under 30 minutes.

 

You can find more information here: http://blogs.msdn.com/sqlperf/archive/2008/02/27/etl-world-record.aspx  Also watch for a paper from the performance team about how this was achieved and lessons learned in this exercise.

 

In addition, the SQL CAT team have been doing work on fast data loads using bulk inserts.  Watch sqlcat.com for TechNotes and best practices learned from this exercise.

Leave a Comment
  • Please add 5 and 2 and type the answer here:
  • Post
  • New post at blogs.msdn.com

  • SSIS 2008 - world record ETL performance - SQL CAT team har sat ny ETL performance rekord. Stort tillykke

  • Authors: Denny Lee, Thomas Kejser, Matt Neerincx Contributors / Reviewers: Peter Carlin, Brandon Berg

  • Authors: Thomas Kejser, Denny Lee Contributors: Runying Mao Technical Reviewers: Burzin Patel, Kevin

  • With this type of high configuration, may be possible to achieve this type of result. But in real time scenario, Informetica is far better that SSIS.

  • Wow!!!

    Awesome!!!  tool from Microsoft.

Page 1 of 1 (7 items)