SSIS 2008 – world record ETL performance

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.