Decision Support: Nieuws.be
Operating System Windows 2008 Enterprise RTM (64-bit)
Software SQL Server 2005 Enterprise x64 SP3 (64-bit)
Benchmark software vApus + real world "Nieuws.be" Database
Database Size > 100 GB
Typical error margin 1-2%

The Flemish/Dutch Nieuws.be site is one of the newest web 2.0 websites, launched in 2008. It gathers news from many different sources and allows readers to personalize their view of all this 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 Servers Lab).

Nieuws.be allowed us to test the MS SQL 2005 database for CPU benchmarking. We used a log taken between 10:00 and 11:00, when traffic is at its peak. vApus, the stress testing software developed by the Sizing Servers Lab, analyzes this log and simulates real users by performing the actions they performed on the website. In this case, we used the resulting load on the database for our test. 99% of the load on the database consists of selects, and about 5% of them are stored procedures. Network traffic is 6.5MB/s average and 14MB/s peak, so our Gigabit connection still has a lot of headroom. DQL (Disk Queue Length) is at 2 in the first round of tests, but we only report the results of the subsequent 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 disks. This test is as real world as it gets! All servers were tested in a dual CPU configuration.

Nieuws.be MS SQL Server 2005

Seven times faster than a 3-year old CPU and 76% faster than an adversary that used to outperform almost every Intel CPU! Nehalem is like a CPU that used a time machine and teleported to 2009 from 2011. To put this kind of performance into perspective: it would take a 4.7GHz Opteron to keep up with Nehalem at 3.03GHz (that's the average clock speed as Turbo mode was enabled).

OLTP - Oracle "Calling Circle" Website - MCS eFMS
POST A COMMENT

44 Comments

View All Comments

  • usamaah - Monday, March 30, 2009 - link

    Is it me or is page 2 of this article missing some information? The title of that 2nd page is "What Intel and AMD are Offering," but in the body of the text there are only descriptions of Intel's Xeon chips? Perhaps a new title to reflect the body, or add AMD info? Reply
  • JohanAnandtech - Monday, March 30, 2009 - link

    I moved the AMD vs Intel pricing data to the back of the article as the pricing info is more interesting once you have seen the results. But forgot to change the title.. fixed. Thanks. Reply
  • usamaah - Monday, March 30, 2009 - link

    Cool, thank you. Next time I'll finish reading the article before I make a comment, sorry ;-) Anyway wonderful article. Reply
  • Ipatinga - Monday, March 30, 2009 - link

    Very nice to see a comparison over some generations of Xeon platform, including the new one (yet to be released).

    I would like to see a new article with Core i7 vs Xeon 5500... to check out if my Core i7 @ 3,7GHz is good enough in Maya 2009 (Windows XP 64bit, 12GB DDR3), or if a Xeon 5500 (each at 2,4GHz, for instance) in dual processor configuration will be a much better buy.
    Reply

Log in

Don't have an account? Sign up now