Welcome to EMC Consulting Blogs

Aww, so skeptical? :)

The SQL Perf blog has posted the details of how the record was set. Check it out.

http://blogs.msdn.com/sqlperf/archive/2008/02/27/etl-world-record.aspx

records tend to be in the details :)

Does that mean they have qualified for the Beijing Olympics?  

I would love to see standard benchmark test for ETL tools but I think Microsoft would lose out in the Unix, Linux and z/os benchmarks!  Not to mention the DB2, Oracle, Teradata, Sybase etc load benchmarks.  The "old" world record by Informatica and Sun is over two years old so I guess that means Microsoft are only two years behind Informatica PowerCenter.  Informatica have spent US$100 on software development and released two new versions since then so I'm guessing 1TB in 33 minutes would be a piece of cake for Informatica and Sun on the latest hardware.

Microsoft has published a performance benchmark on loading 1TB of data using ETL stuff in SSIS 2008.

I don't understand it, either Jamie. Vincent, PowerCenter's a fine product, but your post sounds like sour grapes. C'mon, how 'bout at least a tip of the hat?

I'd also like to correct the facts: the last Informatica result came out on August 14, 2006, so it's been about 18 months.

http://www.informatica.com/news/press_releases/2006/08142006a_hp_server.htm

Too, we didn't use the fastest available processors on our new result, so it's quite comparable to the previous record. And we bundle SSIS with most SQL Server SKUs, so we should also talk about record price/performance. :)

I'm sure someone will beat this result (we have already), that's the nature of benchmarks. The important thing is that we're finally trying, and doing so will help us deliver a better SSIS product for customers when we release SQL Server 2008. What's not to like about that?