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: Logo

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

Google photo

You are commenting using your Google 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 )

Connecting to %s