The “Balanced Data Distributor” for SSIS

The “Balanced Data Distributor” for SSISLen Wyatt, SQL Server Performance Team There is a new transform component available for SQL Server Integration Services.  It’s called the Balanced Data Distributor (BDD) and the download is available here.  The BDD provides an easy way to amp up your usage of multi-processor and multi-core servers by introducing parallelism…


Kilimanjaro Ships!

SQL Server 2008 R2 launches today! While the name “R2” sounds like an incremental update to SS2008 (or half of a Star Wars droid), in fact Kilimanjaro (the internal code name) is packed with big features. We’ve also got a lot to show for our work on performance and scalability. The four results at the…

1

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

Windows Server 2008 + SQL Server 2008 = Geo-replication Benefits

After running an experiment, using datacenters on each coast of the U.S., our friends in MSCOM ops verified that the combination of Windows Server 2008 and SQL Server 2008 are great for enabling database geo-replication, thanks to a 100X gain in performance. The experiment provided sufficient evidence to motivate a more ambitious proof-of-concept case study with…

0

SQL Server is Movin’ On Up!

At last week’s WinHEC in Los Angeles, SQL GM Quentin Clark joined Windows Server VP Bill Laing on stage, to announce our upcoming support for more than 64 logical processors, the current limit in Windows and SQL Server. This expanded scale-up capability is planned to be released in SQL Server code named “Kilimanjaro”, when running…

1

TPC-E – Raising the Bar in OLTP Performance

Glenn Paulley, Director of Engineering at Sybase iAnywhere, posted a commentary titled “The State of TPC-E” on his blog three weeks ago (10/3/08).  A better title would have been “All TPC-E Results Are On Microsoft SQL Server.  Why?”  Mr. Paulley takes issue with Brian Moran’s statement that “the most rational answer is that Oracle and…

6