ETL World Record For SQL Server 2008

Microsoft’s Len Wyatt, Tim Shea, and David Powell have new White Paper up on MSDN that details their successful effort to load 1 terabyte of data in less than 30 minutes using SSIS on SQL Server 2008, running on Windows Server 2008. They actually did this back in February 2008, on a pre-release build of SQL Server 2008.

The picture below shows the hardware that they used to do this, which is fairly high-end, but not outrageously so. There is a lot of good configuration and tuning information in the article, which I highly recommend.

Technorati Tags:

This entry was posted in SQL Server 2008. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s