The Xeon E5-2600: Dual Sandy Bridge for Servers
by Johan De Gelas on March 6, 2012 9:27 AM EST- Posted in
- IT Computing
- Virtualization
- Xeon
- Opteron
- Cloud Computing
SQL Server 2008 Enterprise R2
We have been using the Flemish/Dutch Web 2.0 website Nieuws.be as a benchmark for some time. 99% of the loads on the database are selects and about 5% of them are stored procedures. You can find a more detailed description here.
We have improved our testing methodology (read more about it here) and updated the SQL Server, so the results are only comparable to our last Opteron 6276 review (and not comparable to older ones than the latter).
Since performance/watt is an extremely important metric, we follow up with a power measurement:
The Xeon E5-2690 is by far the fastest in this discipline, but the difference power consumption compared to the rest of the pack is significant. The Xeon E5-2690 needs 140W more than its slower brother, the 95W TDP Xeon E5-2660. That is 70W extra per CPU. This clearly indicates that the fastest Xeon is running closer to its TDP than the 2.2 GHz version. The Xeon E5-2660 offers more than 20% better performance per Watt than the 135W TDP Xeon.
The Xeon E5-2660 is especially impressive if you compare it with the older Xeon. Despite the lower clockspeed, the new Xeon is capable of outperforming the Xeon 5650 by 30%.
Clock for clock, core for core the Xeon E5 is 23% more efficient at SQL Server workloads than its older brother. Considering that it is pretty hard to extract higher IPC out of server workloads, we can say that the Sandy-Bridge architecture is a winner when it comes to SQL databases.
Finally, let's check out the response times with 600 users sending off a query every second (on average):
Response times are more or less linear (and low!) when the server is not yet saturated . Once the server is closer to or over its maximum throughput, response times tend to increase almost exponentially. Since the Xeon E5-2690 is capable of sustaining more than 600 users, it can still offer a very low response time. The other CPUs are saturated at this point.
But as we pointed out in our previous article, server benchmarks at 100% are just one datapoint and we should test at lower concurrencies as well. Most people try to make sure that their database server almost never runs at 100% CPU load.
Facebook
Twitter
RSS
81 Comments
View All Comments
dilidolo - Tuesday, March 6, 2012 - link
Link not working on first page - THE SPECS AND THE SKUSyvizel - Tuesday, March 6, 2012 - link
For some reason I cannot go beyond the first page...yvizel - Tuesday, March 6, 2012 - link
Second page, in the Intel table, the 2630 is listed as an eight core CPU.But then: "...Based on the paper specs, AMD's 6276, 6274 and Intel's 2640 and 2630 are in a neck-and-neck race. AMD offers 16 smaller integer clusters, while Intel offers 6 heavy, slightly higher clocked cores with SMT..."
JohanAnandtech - Tuesday, March 6, 2012 - link
Fixed, thanks for letting me know!-Johan
Assimilator87 - Tuesday, March 6, 2012 - link
Ah man, the 2630L error totally got my hopes up. 8 cores for $662 would be very reasonable.jumjjcmsw - Thursday, November 10, 2016 - link
How do celebrities keep fit and be always on top? Simple, complete with exercise and of course the right diet. In Hollywood it every day a new diet is devised that promises weight loss in a short time and a fabulous body. From the fasting diet to that of the Paleolithic, up to that of the blood type, the stars follow them a bit 'all.http://www.celebritiesphonenumber.com/baby-ariel-p...
Kjella - Tuesday, March 6, 2012 - link
...just got bulldozed. And this isn't even on the 22nm 3D transistors they're launching next month, it's like they just got a dizzying punch and know the KO punch is coming.A5 - Tuesday, March 6, 2012 - link
It'll probably be awhile before the Ivy Bridge Xeons are out.Kjella - Tuesday, March 6, 2012 - link
Of course, I'm guessing Q1 2013 before we'll see those but we already know from all the leaked SB -> IB details roughly what SB-Xeon to IB-Xeon will be like. All AMD has on their roadmap for 2013 is the "Abu Dhabi" with the "Piledriver" core promising 10-15% performance boost but still on 32nm. So you can see the punch coming a year away, but I don't think AMD has the capability to do anything about it.saharadusud - Saturday, January 7, 2017 - link
http://clashroyalehacke.com/Do you want unlimited gems, gold and elixirs without spending money? You can enjoy free gems by using the Clash Royale Hack with the latest version, easy to use with proxy support. With such a feature, you can truly enjoy yourself in the game and complete things you want without much trouble. This will make your time spent playing either less hard work and more fun. This is why we recommend our tool for all enthusiasts of the video game.
The good news is that this tool works well with any Android phone, iPad, PC and iPhone. What's even better is the fact that this tool is free to use for any player who wants to take full advantage of its features. This is the Clash Royale Hack tool that can be used to generate Clash Royale gems easily and for free. This works in a secure manner, which will allow you to remain reassured in the integrity of your account if you use our tool. Sit down and relax as you continue to generate free gems for you.