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.
System Availability Date
Server Procs/ Cores/ Threads
NEC Express5800/ A1080a-E
Intel Xeon X7560 2.26GHz
IBM System x3850 X5
Unisys ES7000 Model 7600R Enterprise Server (16s)
Intel Hex-core Xeon X7460 2.66GHz
Dell PowerEdge R910
Intel Xeon-Quad Core x7560 2.27GHz
HP ProLiant DL385G7
AMD Opteron(tm) 6176 SE 2.3GHz
You can find out more about R2 at www.sqlserverlaunch.com.
- Charles Levine