sqlskills-logo-2015-white.png

Intel Xeon E5-2600 v2 Series Processors (Ivy Bridge-EP) in Q3 2013

More details about the upcoming 22nm Intel Xeon E5-2600 series processors (aka Ivy Bridge-EP) are starting to leak out. Initially, we will see the single-socket Xeon E5-1600 v2 series and the two-socket Xeon E5-2600 v2 series processors, that share the 22nm Ivy Bridge microarchitecture. They use the same LGA2011 socket as the current 32nm E5-1600 and E5-2600 series (Sandy Bridge-EP), so that should mean that they will show up quickly in existing server models, such as the Dell PowerEdge R720 and the HP ProLiant DL380p Gen 8.

The chart that TechPowerUp found does not show the physical core count for each processor model, but we can infer that based on the total L3 cache size, since Intel has been using 2.5MB of shared L3 cache for each physical core in the Sandy Bridge and Ivy Bridge microarchitectures. That means you can divide the L3 cache size (in MB) by 2.5 to get the physical core count. Based on this calculation, it looks like the Intel Xeon E5-2600 v2 processors will have from eight to twelve physical cores. The Xeon E5-2697 v2 and E5-2695 v2 have twelve physical cores and a 30MB shared L3 cache, which means that you give up quick a bit of base clock speed to get twelve cores. If you want to minimize your physical core counts for SQL Server 2012 licensing purposes, the eight-core, 2.6GHz Xeon E5-2650 v2 would be a good choice. I am a little surprised that there is not a four or six-core model in the lineup, but we may not have all of the available models yet. Table 1 shows the known specifications for the Xeon E5-2600 v2 series processors.

Model Physical Cores Base Clock Speed L3 Cache Size
Xeon E5-2640 v2 8 2.0GHz 20MB
Xeon E5-2643 v2 10 (??) 3.5GHz 25MB
Xeon E5-2650 v2 8 2.6GHz 20MB
Xeon E5-2650L v2 10 1.7GHz 25MB
Xeon E5-2660 v2 10 2.2GHz 25MB
Xeon E5-2667 v2 10 3.3GHz 25MB
Xeon E5-2670 v2 10 2.5GHz 25MB
Xeon E5-2680 v2 10 2.8GHz 25MB
Xeon E5-2687W v2 10 3.4GHz 25MB
Xeon E5-2690 v2 10 3.0GHz 25MB
Xeon E5-2695 v2 12 2.4GHz 30MB
Xeon E5-2697 v2 12 2.7GHz 30MB

Table 1: Intel E5-2600 v2 Series Model Information

I am a little suspicious of the core count and L3 cache size for the Xeon E5-2643 v2. I think it is more likely to have eight physical cores and a 20MB L3 cache based on it’s base clock speed. Even though the Ivy Bridge-EP core counts are up to 50% higher than the 32nm Xeon E5-2600 series, the TDP ratings are about the same, which shows the benefits of moving to a smaller 22nm manufacturing process. The only low-power SKU in the lineup is Xeon E5-2650L v2. It has ten CPU cores, a 1.7 GHz base clock speed, and a 70 Watt TDP rating. It would not be a good choice for SQL Server, since you give up a significant amount of performance to save perhaps 20-30 watts of electrical usage per processor. The Xeon E5-2600 v2 processors are supposed to have two QPI 1.1 links, up to 40 lanes of PCI Express 3.0 interface, and a 4-channel DDR3 memory controller that supports DDR3-1866 memory.

You should be able to get an existing model server with these processors sometime in July. Getting a two-socket system with two Intel Xeon E5-2690 v2 processors will be a pretty compelling choice for a lot of SQL Server 2012/2014 workloads. I predict we will see TPC-E scores in the 2500-2600 range for that type of system, which compares quite well to a four-socket, Intel E7-4870 system that would cost twice as much for SQL Server 2012 Enterprise core licenses.

Leave a Reply

Your email address will not be published. Required fields are marked *

Other articles

Imagine feeling confident enough to handle whatever your database throws at you.

With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.