Archive 1997–2024

Balancing Power, Price, and Performance in the Server CPU World

SQL Server 2008

The Flemish/Dutch site Nieuws.be is a web 2.0 website launched in 2008. It gathers news from many different sources and allows the reader a personalized view on all the news. The Nieuws.be site sits on top of a large database—more than 100GB and growing. This database consists of a few hundred separate tables, which have been carefully optimized by our lab (the Sizing Server Lab). We use a log from their site for this test.

99% of the loads on the database are selects and about 5% of them are stored procedures. Network traffic is 6.5MB/s average and 14MB/s at the most, so our Gigabit connection still has a lot of headroom. Disk Queue Length (DQL) is at 2 in the first round of tests, but we only report the results of the next rounds where the database is in a steady state. We measured a DQL close to 0 during these tests, so there is no tangible impact from the hard disk speed.

Note: Starting with our twelve-core Opteron review, we are using a new heavier log. The Nieuws.be application has become more popular and more complex, the database has grown, and queries have become more complex too. The results are no longer comparable to previous results. They are similar, but much lower.

Nieuws.be MS SQL Server 2008 (new heavy log)

At first you might surprised that the Intel chips win here, as this was one of the benchmarks where AMD's high-end CPUs excel. But of course, we should not forget that the Magny-cours chips like the Opteron 6174 had twice as many cores as its Xeon competitors. The "Lisbon" CPU only has 50% more cores than its typical Xeon alternatives.

Originally published at https://www.anandtech.com/show/4193/cheap-and-low-power-server-cpus-compared (Wayback Machine).