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
zavrach - Thursday, May 5, 2016 - link
Good article! We are linking to this great content on our website.Keep up the great writing.
my site : https://www.reddit.com/r/iosgameshack/comments/4h3...
kiiiif - Tuesday, May 10, 2016 - link
<a href="http://www.celebritiesphonenumber.com/">ht...And if the fans will have to wait quietly until 20 May 2016 to discover the album Dangerous Woman in full today a new song he has appeared on the web! Discover now the sexy duo Let Me Love You with Lil Wayne.
kiiiif - Tuesday, May 10, 2016 - link
Another promising title! While for several days extract Let Me Love You is available on the web, is now the entire song that fans can listen Ariana Grande.http://www.celebritiesphonenumber.com/
Ucajuef - Tuesday, May 24, 2016 - link
But capping smartphone market hits them most on component suppliers. Sony reported a quarterly loss because of low demand for image sensors used on smartphones. And Sharp is among the Asian suppliers who have recently complained of a decline in demand for components for smart phones.http://www.gpsphone-tracker.net/
JossPonce - Monday, June 13, 2016 - link
Can't put it down not play to win!! My wife and I play this game together. This is the only game I can get her to play we spend night battle all night and talking about strategy: http://bit.ly/1XRl0ZOgerua - Sunday, September 4, 2016 - link
Thank you for sharing this topic with us. I read this topic and found it interesting. You really have a great knowledge. keep up the good work. Just bookmarked your blog for future read. Read my blog heremedelin - Friday, October 28, 2016 - link
http://clash-of-clans-hack-deutsch.de/ can be extremely useful if you use it wisely, and no player can stand a chance against you as long you use this amazing Clash of Clans Hack Deutsch !saharadusud - Saturday, January 7, 2017 - link
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. http://clashroyalehacke.com/
medelin - Saturday, December 10, 2016 - link
http://clash-of-clans-hack-deutsch.de/ is what you need to defeat all the competition and be the first ranked in leaderboard.Georgefvv - Thursday, September 10, 2020 - link
https://clck.ru/QAzehРаньше пользователи CryptoTab PRO могли торопить майнинг только около помощи функции Cloud.Boost. Мы решили начинать дальше и предоставить вам доступ к новейшей опции Super.Boost, чтобы вы зарабатывали больше — и быстрее! Оцените преимущества сверхскоростного майнинга с расширением Super.Boost, доступным в PRO-версии Android приложения.
Используйте сразу несколько ускорений Super.Boost и увеличьте общую прыть майнинга на всех ваших устройствах с включеннойй функцией Cloud.Boost. https://clck.ru/QAzej
Скажем, проворство вашего устройства — 100H/s, с Cloud.Boost X10 живость составит уже 1000H/s. А с двумя дополнительными ускорениями Super.Boost +80% и +60% суммарная скорость майнинга будет равна 2400H/s (1000H/s + 1000H/s*0,8 + 1000H/s*0.6 = 1000 + 800 + 600).
Скачай CryptoTab PRO и открой ради себя сверхбыстрый майнинг! https://clck.ru/QB2Gi
Устанавливая PRO-версию Android-приложения помимо опции Super.Boost, вы также получите расширенный набор функций:
Cloud Aid — часто ускоренный майнинг
Функция SDP: сервер-зависимый майнинг не тратит заряд батареи
Быстрый доступ к кабинету ради хранения и вывода криптовалюты
Неограниченное количество подключённых удалённых устройств
Обновление баланса однажды в 10 минут
Безграничный вывод средств от 0.00001 BTC
Отдельные профили ради разных пользователей
Защищенный профиль для публичного Wi-Fi
Приоритетная техническая помощь
Адаптивная новостная лента
Никакой надоедливой рекламы
Специальные промо-материалы и распродажи
Майнинг для мобильных устройствах снова никогда не был таким быстрым! Скачай Android-приложение, включи Cloud.Boost и открой ради себя суперскоростной майнинг с функцией Super.Boost.
Перейти сообразно ссылке: https://clck.ru/QB2LW
@Crypto_Good