Partilhar via

SSIS 2008 - world record ETL performance

  • Artigo

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: https://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.

Comments

  • Anonymous
    February 28, 2008
    New post at blogs.msdn.com

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

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

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

  • Anonymous
    May 14, 2013
    The comment has been removed

  • Anonymous
    March 18, 2014
    Wow!!! Awesome!!!  tool from Microsoft.