New TPC Results on SQL Server 2008 R2

On November 2, 2009, Unisys published two new TPC results (TPC-E and TPC-H) using the newly announced SQL Server 2008 R2* and Windows Server 2008 R2**.  These results were published on the 96-core Unisys ES7000 system.  These are the first SQL Server TPC results using more than 64 cores and they demonstrate the outstanding scalability…

1

Great New TPC-H Results with SQL Server 2008

  Our partners at Dell and HP have published 2 new TPC-H results with SQL Server 2008 using Fusion-io’s ioDrive solid-state technology.  These are the first TPC results using solid-state technology and they illustrate the high performance along with total cost-of-ownership savings you can achieve.  These results dramatically improved the price/performance for systems using industry…

0

Using SSIS to get data out of Oracle: A big surprise!

Since late last year, Microsoft has made the Attunity connectors to Oracle databases available to Enterprise Edition customers. We all recognized right away that these connectors were faster than the pre-existing options from either Microsoft or Oracle, when moving data into or out of an Oracle database. It wasn’t immediately obvious what speeds we could…

17

Great new SQL Server performance on Intel’s Xeon 5500 series, aka Nehalem-EP

Yesterday, Intel launched its new Xeon 5500 series processors, code named Nehalem-EP. This is essentially the first server-class version of what Intel launched on the desktop as Core i7 last fall. With no frontside bus, and an embedded, multi-channel memory controller in the processor package, it is smoking fast. Pat Gelsinger did a side-by-side performance demo which…

1

An ETL World Record Revealed (Finally)

We suppose a more appropriate title would have been: Better Late Than Never.  David should begin by apologizing. Last month was the first anniversary of the ETL world record we set last year with SSIS, loading 1 TB of data in under 30 minutes. While Len did a nice blog post on the project at the time,…

2