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

  • Veteran - Wednesday, April 1, 2009 - link

    I didn't mean to offend you, because i can imagine how much time it takes to test hardware properly. And i personally think that OLTP/OLAP testing is very innovative and needed. Because otherwise people would have no idea what to buy for servers. You cannot let you server purchase be influenced with meaningless (for servers) simple benchmarks like 3D 2006/Vantage/FPS test etc.
    You guys always are doing a great a job at testing any piece of hardware, but it is just feeling to much biased towards Intel. For example, at the last page of this review you get a link to Intel resource Center (in the same place as the next button). If you have things like that, you are not (trying to be) objective IMO.
    Reply
  • JohanAnandtech - Wednesday, April 1, 2009 - link

    Thank you for clarifying in a very constructive way.

    "the last page of this review you get a link to Intel resource Center"

    I can't say I am happy with that link as it creates the wrong impression. But the deal is: editors don't involve in ad management, ad sales people don't get involved when it comes to content.

    So all I can say is to judge our content, not our ads. And like I said, it didn't stop us from claiming that Shanghai was by far the best server CPU a few months ago. And that conclusion was not on many sites.
    Reply
  • Veteran - Wednesday, April 1, 2009 - link

    Thanks for clarrifying this matter.

    But ad sales people should know this creates the wrong impression. A review site (for me at least) is all about objectivity and credibility. When you place a link to Intel's Resource Center at the end of every review, it feels weird. People on forums already call Anandtech, Inteltech. And i don't think this is what you guys want.

    I always liked Anandtech since when I was a kid, and I still do. You guys always have one of the most in-depth reviews (especially on the very technical side) and I like that. But you guys are gaining some very negative publicity on the net.
    Reply
  • BaronMatrix - Tuesday, March 31, 2009 - link

    Unfortunately, I don't buy from or recommend criminals. Reply
  • carniver - Wednesday, April 1, 2009 - link

    AMDZone is the biggest joke on the internet. I just went there to see how the zealots like abinstein are still doing their damage control; just like before he went on rambling how the Penryn is still weak against Shanghai, and the old and tired excuses like how if people all bought AMD they can drop in upgrades etc etc. ZootyGray...he's the biggest joke on AMDZone. None of them had the mental capacity to accept AMD has been DEFEATED, which is disappointing but funny to say the least Reply
  • duploxxx - Wednesday, April 1, 2009 - link

    It's not just AMDZone, you are just the opposite. Its like in Woodcrest and conroe times, it's not because the high-end cpu is the best of all that the rest of the available cpu's in the line is by default better. It's all about price performance ratio. Like many who were buying the low-end and think they had bought the better system, well wrong bet.

    As mentioned before, why not test the mid range that is where the sales will be. Time to test 5520-5530 against 2380-82 after all those have the same price.
    Reply
  • carniver - Wednesday, April 1, 2009 - link

    Your argument is valid, however, it just so happens that for low end 1S systems the Penryns are doing just fine against the Shanghais, for higher end 2S systems they used to be limited by memory bandwidth and AMD pulls ahead. No more is this the case, Intel now beats AMD in their own territory. Reply
  • CHADBOGA - Tuesday, March 31, 2009 - link

    You probably also can't afford to buy a computer, so I doubt that Intel will be too concerned with your AMDZone insanity. LOL!!!! Reply
  • smilingcrow - Tuesday, March 31, 2009 - link

    Those grapes you are chewing on sure sound sour to me. Try listening to a few tracks by The Fun Loving Criminals to help take away the bad taste. Reply
  • cjcoats - Tuesday, March 31, 2009 - link

    There's more to HPC applications than you indicate: environmental modeling apps, particularly, tend to be dominated by memory access patterns rather than by I/O or pure computation. Give me a ring if you'd like some help with that -- I'm local for you, in fact... Reply

Log in

Don't have an account? Sign up now