Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Selecting an Appropriate Intel Xeon E5-2600 v2 Family Processor for SQL Server 2012

Intel has finally released the 22nm Xeon E5-2600 v2 Family (Ivy Bridge-EP) of processors that will be used in two-socket servers. These processors have slightly better single-threaded performance than the previous 32nm Xeon E5-2600 Family (Sandy Bridge-EP) processors, along with higher physical core counts and lower power usage.

They are pin-compatible with the older Sandy Bridge-EP processors, so they will work in existing two-socket servers, such as the Dell PowerEdge R720 or the HP Proliant DL380p Gen 8. This means that you should be able to get an Ivy Bridge-EP in an existing server model fairly quickly.

Once this happens, the question will be which exact E5-2600 v2 processor you should pick for SQL Server 2012 or SQL Server 2014 usage? Since SQL Server 2012 uses core-based licensing, you really want to get the most performance possible from each physical core that you buy a SQL Server core license for.

There are several different choices available, based on your budget, performance and scalability requirements, ranging from four physical cores without hyper-threading to twelve physical cores with hyper-threading.

Remember, only physical cores count for licensing purposes (on non-virtualized servers). If there are two or more models with the same physical core count, you should prefer the one with the highest clock speed (since the license cost is the same).  You also want to avoid the low-power models (that have the L suffix at the end of the model number). They save a relatively small amount of electrical power at the cost of a pretty significant performance penalty.

This leaves five viable choices, depending on your desired physical core count, as shown in Table 1.

Model Cores Base Speed Turbo Speed
E5-2697 v2 12 2.7 GHz 3.5 GHz
E5-2690 v2 10 3.0 GHz 3.6 GHz
E5-2667 v2 8 3.3 GHz 4.0 GHz
E5-2643 v2 6 3.5 GHz 3.8 GHz
E5-2637 v2 4 3.5 GHz 3.8 GHz

Table 1: Recommended Xeon E5-2600 v2 Processor Models for SQL Server 2012/2014

In my opinion, there is no good technical reason to select any of the other available models from this product family for SQL Server 2012/2014 usage.

I think it is interesting that the new eight-core E5-2667 v2 has higher clock speeds and slightly better single-threaded performance than the previous generation, eight-core E5-2690 processor. The new four-core E5-2637 v2 also has higher clock speeds and slightly better single-threaded performance than the previous generation, four-core E5-2643 processor. Getting better performance for the same SQL Server 2012 license cost is always a good thing!


Filed under: Computer Hardware, Intel, Ivy Bridge-EP, SQL Server 2012 Tagged: Intel Xeon E5-2600 v2

Comments

Leave a comment on the original post [sqlserverperformance.wordpress.com, opens in a new window]

Loading comments...