Decision Support benchmark: Nieuws.be

Decision Support benchmark Nieuws.be
Operating System Windows 2008 Enterprise RTM (64 bit)
Software SQL Server 2008 Enterprise x64 (64 bit)
Benchmark software vApus + real-world "Nieuws.be" Database
Database Size > 100GB

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 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).

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 intervention of the hard disks.

Attention: since our twelve-core Opteron review, we are using a new heavier log. As the Nieuws.be application became 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!

First, you may notice that our dual Xeon X5670 is 6% higher compared to what we reported in our twelve-core Opteron review. As we changed the benchmark and tested a lot of configurations in less than a week (before the launch of the Magny-Cours Opteron), we made an error. We tested with the power option set at "balanced power", which lowered the score of the Xeon X5670. We now tested with the "high performance" power setting, as we did on the Opterons.

Our data mining benchmark scales well with more cores, so the performance delivered by the X7560 is a bit lower than expected. The high memory latency and relatively low bandwidth per core might slow the octal-core Xeon down.

Understanding the Performance Numbers SAP S&D 2-Tier
POST A COMMENT

23 Comments

View All Comments

  • klstay - Thursday, April 15, 2010 - link

    I agree. Being able to use all the DIMM slots in the R810 with only half the CPU sockets populated is a neat trick, and I do like having up to 16 drive bays in the R910, but overall the latest IBM 3850 is much more flexible than either of those systems. From a 2 socket 4 cores each system with 32GB RAM up to an 8 socket 8 cores each system with 3TB RAM. Barring some big surprises at HPs announcement in a couple of weeks IBM will be the one to beat in Nehalem EX for the foreseeable future. Reply
  • Etern205 - Thursday, April 15, 2010 - link

    The AMD Opteron 6128 isn't $523.
    It's $299.99!

    http://www.newegg.com/Product/Product.aspx?Item=N8...

    (credited to: zpdixon @ DT for providing the link)
    Reply
  • yuhong - Tuesday, June 15, 2010 - link

    "but when a dual-CPU configuration outperforms quad-CPU configurations of your top-of-the-line CPU, something is wrong. "
    Remember Xeon 7100 vs Xeon 5300?
    Reply

Log in

Don't have an account? Sign up now