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 top of the TPC-E performance chart are all on R2. This includes two results with more than 64 hardware threads, possible because of support added in Windows Server 2008 R2 and SQL Server 2008 R2 for up to 256 logical processors. The published results span the range from 2 to 16 CPUs, 24 to 96 cores, and 24 to 128 hardware threads.  No one else has shown performance and scalability on TPC-E, the most rigorous industry-standard measure of OLTP performance available today. (See TPC-E – Raising the Bar in OLTP Performance for details on TPC-E.)

Five TPC-E benchmark results on SQL Server 2008 R2 published to date with five hardware partners show how SQL Server is driving scalability to new levels on x64 servers.  The top result more than doubles the top perf on SQL Server 2008. Congratulations to Intel on the performance of the Nehalem-EX processor, which now holds the top two performance positions. (See this video for more on the breakthrough performance of Windows and SQL Server on Nehalem-EX.)

Here are the TPC-E results published on SQL Server 2008 R2 as of 4/20/10. 

Sponsor

System

tpsE

Price/
tpsE

System Availability
Date

Server Procs/
Cores/
Threads

CPU Type

clip_image001

NEC Express5800/ A1080a-E

3,141

768.92
USD

6/24/10

8/64/128

Intel Xeon X7560 2.26GHz

clip_image002

IBM System x3850 X5

2,022

493.92
USD

7/30/10

4/32/64

Intel Xeon X7560 2.26GHz

clip_image003

Unisys ES7000 Model 7600R Enterprise Server (16s)

2,012

958.23
USD

5/6/10

16/96/96

Intel Hex-core Xeon X7460 2.66GHz

clip_image004

Dell PowerEdge R910

1,933

328.58
USD

5/6/10

4/32/64

Intel Xeon-Quad Core x7560 2.27GHz

clip_image005

HP ProLiant DL385G7

887

296.00
USD

5/6/10

2/24/24

AMD Opteron(tm) 6176 SE 2.3GHz

You can find out more about R2 at www.sqlserverlaunch.com.

- Charles Levine