Second TPC-E Benchmark Result Published For SQL Server 2012

NEC has submitted the second TPC-E OLTP benchmark result for SQL Server 2012, running on an Express5800/A1080a-E system, which is a new record of 4614.22 TpsE. This is for an eight socket system with 2.4GHz Intel Xeon E7-8870 processors, 2048GB of RAM, and 472 spindles (including 396 SSDs).

About a month ago, IBM submitted the first TPC-E OLTP benchmark result for SQL Server 2012 on a System x3650 M4, with a score of 1863.23 TpsE. This is for a two socket system with 2.9GHz Intel Xeon E5-2690 processors, 512GB of RAM, and 92 spindles.

System Score CPU Processors Cores
NEC Express5800/A1080a-E 4614.22 E7-8870 8 80
IBM System x3650 M4 1863.23 E5-2690 2 16

If you divide the TpsE score by the number of physical cores in each system, you get a result of 57.68 for the Xeon E7-8870 system, and 116.45 for the Xeon E5-2690 system. This shows that the Xeon E5-2690 is capable of about twice the TpsE performance per physical core compared to the Xeon E7-8870. This is very significant for the new SQL Server 2012 core-based licensing, where you are paying five times the SQL Server license cost to get 2.47 times the TpsE score in this case. This is yet more evidence that the Xeon E5-2690 does extremely well on OLTP workloads!

About these ads
This entry was posted in Computer Hardware, Microsoft, Processors, SQL Server 2012 and tagged . Bookmark the permalink.

3 Responses to Second TPC-E Benchmark Result Published For SQL Server 2012

  1. datatake says:

    Hi Glenn,

    What is the ingestion rate for these CPU’s, I know that the Microsoft fast track methodology for data warehouses assumes a rate of 200Mb/s per core, I would hazard a guess this is much more for this latest generation of processors.

    Regards,

    Chris

  2. kevinclosson says:

    Good post, Glenn.

    Another observation is that Sandy Bridge EN is demonstrating the better bang for the DRAM buck as it were. The E7 result is 2.25TpsE/GB whereas the E5 is 3.63TpsE/GB. So I wonder what the landscape would be like if IBM produces an X5 system (with MAX5) with four sockets Sandy Bridge EP and very large memory (4TB?). All speculation on my part as I don’t know IBM’s road map but complementing a 4-way SNB-EP with MAX5 memory (VLM) would seem to be quite a nice package and the natural progression that particular edge of the System x family.

    Do you have any thought on that?

  3. The per-core SQL license costs certainly stand out in the full-disclosure reports. Conveniently, the 8-socket NEC Express5800/A1080a-E has TPC-E results for both SQL 2008 and SQL 2012, with identical database server configurations.

    SQL 2012 (Result 112032702) — Licence cost $538,900 (26% of total system price)
    SQL 2008 (Result 111042801) — License cost $153,504 (13% of total system price)

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s