THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Joe Chang

Intel Xeon E5 (Sandy Bridge-EP) and SQL Server 2012 Benchmarks

Intel officially announced the Xeon E5 2600 series processor based on Sandy Bridge-EP variant with upto 8 cores and 20MB LLC per socket. Only one TPC benchmark accompanied product launch, summary below.

ProcessorsCores perFrequencyMemorySQLVendorTPC-E
2 x Xeon E5-269082.9GHz512GB (16x32GB)2012IBM1,863.23
2 x Xeon E7-2870102.4GHz512GB (32x16GB)2008R2IBM1,560.70
2 x Xeon X569063.46GHz192GB (12x16GB)2008R2HP1,284.14

Note: the HP report lists SQL Server 2008 R2 Enterprise Edition licenses at $23,370 per socket.
The first IBM report lists SQL Server 2012 Enterprise Edition licenses at $13,473 per pair of cores(?) or $53,892 per socket. All results used SSD storage. The IBM E7 result used eMLC SSDs, the IBM E5 results showed more expensive SSDs, but did not explicitly say SLC?.

The Xeon E5 superceeds 2-socket systems based on both the Xeon 5600 (Westmere-EP) and Xeon E7 (Westmere-EX). It is evident that Sandy Bridge improves performance over Westmere at both the socket and core levels and also on a GHz basis.

ArchitectureTotal CoresFrequencyCore-GHzTPC-Etps-E per core-GHz
Sandy Bridge-EP2 x 8 = 162.9GHz46.41,863.2340.16
Westmere-EX2 x 10 = 202.4GHz48.01,560.7032.51
Westmere-EP2 x 6 = 123.46GHz41.521,284.1430.93

One advantage of the Xeon E7 (Westmere-EX) system is that the memory expanders support for 4 DIMMs per channel or 16 DIMMs per socket (4 memory channels). However, a two-socket Sandy Bridge-EP system supports 256GB with 16 (8 per socket) of the lower price (per GB) 16GB DIMMs. And really, 256GB is more than enough for most situations, so it is quite reasonable to not burden outlier configuration requirements on the large majority.

A later version of the Xeon E5 will support 4-socket systems. There is no explanation as to whether glue-less 8-socket systems will be supported in the future. It was previously discussed that there would a EN variant of Sandy Bridge with 3 memory channels and fewer PCI-E lanes.

Hardware Strategy for SQL Server 2012 per core licensing
Top frequency on the 6 core E5-2667 is 2.9GHz, the same as the 8 core (excluding the 8 core 2687W model at 3.1GHz). Top frequency for the 4 core E5-2643 and 2 core E5-2637 are 3.3 and 3.0GHz respectively. The desktop i7-2830 is 3.6GHz with 4 cores, so Intel is deliberately constraining the top frequency on 2 & 4 core version for the server parts, apparently to favor interest in the 8 core part.

Given the SQL Server 2012 per core licensing, there should be interest in a system with fewer cores per socket running at higher frequency, while taking advantage of the high memory and IO bandwith of the E5 system. Consider also that SQL Server write operations (Insert, Update, Delete, the final stage of index builds) and even certain SELECT operations are not parallel (the Sequence Project operator that support the ROW_NUMBER function).

I think it would also make sense for Intel to allow cores to be disabled in BIOS (now UEFI) on the top of line E5-2690 like the desktop extreme edition unlocked processors. Large corporate customers can buy a batch of identical systems, disabling cores that are not needed on individul systems. 

It would also be of value to engage a (nolonger quite so, relative to core licenses) exhorbitantly priced consultant to tune SQL Server to run on fewer cores.(Not to be construed as a solicitation for services)

Published Wednesday, March 7, 2012 7:53 PM by jchang
Filed under: , ,

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

joe schmoe said:

Show me the Benches!

How about a 2012 vs 2008 vs 2005 vs 2000 shootout?

Now who wants a permanent PASS ban!?

March 16, 2012 10:27 PM
 

martin garix said:

How to fix connections for bluetooth audio devices and wireless displays in windows 10,window are comes with the many new features http://fixwindows10connections.com so,first update your window then get the more related info.

January 3, 2019 10:56 PM
 

Jacob said:

The per-center SQL permit costs positively emerge in the complete honesty reports. Advantageously, the 8-attachment NEC Express5800/A1080a-E has TPC-E results for both SQL 2008 and SQL 2012, with indistinguishable database server arrangements. (https://www.assignmentsquare.co.uk/assignment-writing-service)

February 14, 2019 5:14 AM
 

Jacob said:

don’t know from where I will get proper information for my assignment. To solve this issue many assignment  online service are available in market.  https://www.allassignmenthelp.com/java-assignment-help.html

February 20, 2019 2:47 AM
 

Assignment Help said:

For a change, there is an article that focuses on a specific topic and is not all over the places. I like the fact that it is actually problem-solving and not just random and baseless subject. Great going!

<a href="https://www.alphaassignmenthelp.com/project-management-assignment/">Project Management Assignment</a>

<a href="https://www.alphaassignmenthelp.com/thesis-writing-help/">Thesis Writing Help</a>

<a href="https://www.alphaassignmenthelp.com/management-assignment-help/">Management assignment writing services</a>

<a href="https://www.alphaassignmenthelp.com/marketing-assignment-help/">Marketing Assignment writing services</a>

<a href="https://www.alphaassignmenthelp.com/case-study-assignment-writing/">Case study assignment writing</a>

<a href="https://www.alphaassignmenthelp.com/project-management-assignment/">Project Management Assignment</a>

<a href="https://www.alphaassignmenthelp.com/essay-help/">pay for essay</a>

<a href="https://www.alphaassignmenthelp.com/mba-assignment-help/">mba essay writing service</a>

<a href="https://www.alphaassignmenthelp.com/dissertation-writing-services/">Dissertation Help Online</a>

<a href="https://www.alphaassignmenthelp.com/project-management-assignment/">Project Management Assignment</a>

<a href="https://www.alphaassignmenthelp.com/research-paper-writing/">Research Paper Outline</a>

<a href="https://www.alphaassignmenthelp.com/business-plan-writing/">creating a business plan</a>

<a href="https://www.alphaassignmenthelp.com/research-paper-writing/">Research Papers Example</a>

<a href="https://www.alphaassignmenthelp.com/economics-assignment-help/">economics homework help</a>

<a href="https://www.alphaassignmenthelp.com/marketing-assignment-help/">college assignment help</a>

<a href="https://www.alphaassignmenthelp.com/marketing-assignment-help/">marketing assignment</a>

<a href="https://www.alphaassignmenthelp.com/economics-assignment-help/">economics homework help</a>

<a href="https://www.alphaassignmenthelp.com/marketing-assignment-help/">college assignment help</a>

<a href="https://www.alphaassignmenthelp.com/marketing-assignment-help/">marketing assignment</a>

<a href="https://www.alphaassignmenthelp.com/marketing-assignment-help/">college assignment help</a>

<a href="https://www.alphaassignmenthelp.com/marketing-assignment-help/">marketing assignment</a>

<a href="https://www.alphaassignmenthelp.com/assignment-help/">assignment help</a>

<a href="https://www.alphaassignmenthelp.com/assignment-help/">academic assignment help</a>

<a href="https://www.alphaassignmenthelp.com/mba-assignment-help/">mba assignment help</a>

<a href="https://www.alphaassignmenthelp.com/essay-help/">essay help</a>

<a href="https://www.alphaassignmenthelp.com/essay-help/">essay writing help</a>

<a href="https://www.alphaassignmenthelp.com/writing-help/">writing help</a>

<a href="https://www.alphaassignmenthelp.com/writing-help/">assignment writing help</a>

<a href="https://www.alphaassignmenthelp.com/report-writing-services/">report writing services</a>

March 23, 2020 2:07 PM
 

khalsa store said:

Everything is perfect with this work. The writer has managed to keep the article interesting while discussing some really serious points. This is not easily done. All the best.

<a href="http://www.khalsastore.com">">http://www.khalsastore.com"> Buy Kurta Pajama Online  </a>

<a href="http://www.khalsastore.com">">http://www.khalsastore.com"> sikh accessories</a>

<a href="http://www.khalsastore.com">">http://www.khalsastore.com"> Buy Kirpan Online  </a>

<a href="http://www.khalsastore.com">">http://www.khalsastore.com"> Khalsa  </a>

<a href="http://www.khalsastore.com">">http://www.khalsastore.com"> Buy Turbans Online - Sikh Pagri for Men in India</a>

<a href="http://www.khalsastore.com">">http://www.khalsastore.com"> Buy Parna Online </a>

<a href="http://www.khalsastore.com">">http://www.khalsastore.com">turbans for sale </a>

<a href="http://www.khalsastore.com">">http://www.khalsastore.com"> Buy Kachera Online </a>

<a href="http://www.khalsastore.com">">http://www.khalsastore.com"> Buy Parna Online </a>

<a href="http://www.khalsastore.com">">http://www.khalsastore.com"> Rumala Sahib </a>

<a href="http://www.khalsastore.com">">http://www.khalsastore.com"> Buy Punjabi Jutti Online </a>

<a href="http://www.khalsastore.com">">http://www.khalsastore.com"> Patkas </a>

<a href="http://www.khalsastore.com">">http://www.khalsastore.com"> Turban Pins </a>

<a href="http://www.khalsastore.com">">http://www.khalsastore.com"> Chandoa Sahib </a>

<a href="http://www.khalsastore.com">">http://www.khalsastore.com"> Buy Brass Utensils Onlin </a>

<a href="http://www.khalsastore.com">">http://www.khalsastore.com"> Kaintha </a>

<a href="http://www.khalsastore.com">">http://www.khalsastore.com"> Buy Kanga Online </a>

<a href="http://www.khalsastore.com">">http://www.khalsastore.com"> Car Hangings </a>

<a href="http://www.khalsastore.com">">http://www.khalsastore.com"> Chadra </a>

<a href="http://www.khalsastore.com">">http://www.khalsastore.com"> Buy Chola Online </a>

<a href="http://www.khalsastore.com">">http://www.khalsastore.com"> 1984 </a>

<a href="http://www.khalsastore.com">">http://www.khalsastore.com"> turbans </a>

<a href="http://www.khalsastore.com">">http://www.khalsastore.com"> turban </a>

<a href="http://www.khalsastore.com">">http://www.khalsastore.com"> kirpan </a>

<a href="http://www.khalsastore.com">">http://www.khalsastore.com"> Designer Sikh Kirpans in Indiab  </a>

<a href="http://www.khalsastore.com">">http://www.khalsastore.com"> Punjabikurtaforsale </a>

<a href="http://www.khalsastore.com">">http://www.khalsastore.com"> StoreWorld's largest Online shopping store for Punjabi and Sikh Accessories  </a>

<a href="http://www.khalsastore.com  </a>

<a href="http://www.khalsastore.com">">http://www.khalsastore.com">khalsa  kirpan </a>

April 10, 2020 4:10 AM
 

Emma said:

The main condition for writing a successful IB extended essay is focusing on a right topic.  If you are looking for some interesting ideas, it is recommended to check this guideline https://prime-essay.net/ib-extended-essay

April 14, 2020 5:09 AM
 

roman said:

I am reading this post with keen interest but it is useful for a developer and I do like it because writing is my occupation and I have a very short time after completing the assignments for the University students.  https://www.theacademicpapers.co.uk/dissertation-writing-services-uk.php

November 10, 2020 9:05 PM

Leave a Comment

(required) 
(required) 
Submit

About jchang

Reverse engineering the SQL Server Cost Based Optimizer (Query Optimizer), NUMA System Architecture, performance tools developer - SQL ExecStats, mucking with the data distribution statistics histogram - decoding STATS_STREAM, Parallel Execution plans, microprocessors, SSD, HDD, SAN, storage performance, performance modeling and prediction, database architecture, SQL Server engine

This Blog

Syndication

Privacy Statement