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
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 the reader to completely personalize his view on all this news. Needles to say, the Nieuws.be site is sitting of top of a pretty large database, more than 100 GB and growing. This database consists of a few hundred separate tables, which have been carefully optimized by our lab (the Sizing Server Lab).

Nieuws.be was so kind to let us test the MS SQL 2008 database for CPU benchmarking. We used a log taken between 10 and 11 AM, when traffic is at its peak. VAPUS, the stress testing software developed by the Sizing Server 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 are selects, about 5% of them are stored procedures. Network traffic is 6.5 MB/s average and 14 MB/s at the most. So our 1 gigabit connection has still 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 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 intervention of the harddisks. This test is as real world as it gets! All servers were tested in a dual CPU configuration.

Nieuws.be MS SQL Server 2008

The Dual Xeon X5670 is not scaling so well here, as 50% more cores only result in 20% higher performance. Still, until the newest AMD Opterons arrive, there is not any competition for the six-core Xeon. It outperforms the nearest competitor by 40%.

SAP Sales and Distribution 2-tier Virtualization & consolidation
POST A COMMENT

39 Comments

View All Comments

  • landerf - Tuesday, March 16, 2010 - link

    I always wish with these server/workstation part reviews that we could get a gaming page just for kicks. Specifically in this case I'm thinking of the upcoming dual socket EVGA board and if it will have any effect on games or if it will be only synthetics that show a benefit. I'd also like to see a modern workstation card vs it's mainstream counterpart to see if the gaming performance gap has gotten smaller or larger over the years. I think recently there's been a push to make workstation cards do better in 3d games so you can test your work on the same rig, cutting back on the number of systems. Reply
  • GeorgeH - Tuesday, March 16, 2010 - link

    I'd also be curious to see the E5620 overclocked in a consumer board, as its ~$400 price fills the hole between the ~$300 i7-920/930 and the ~$600 i7-950 rather nicely.

    Intel's PR people would probably get pissed, but screw 'em.
    Reply
  • jonup - Tuesday, March 16, 2010 - link

    I was about to post the same. There is a lot of people using Xeons in X58 and P55 boards. Some prefer the lower power consumption others beleive the Xeons oc better. Please show us the money! Reply
  • DigitalFreak - Tuesday, March 16, 2010 - link

    You do realize that the 55xx/56xx series Xeons only work in dual socket motherboards?!? Reply
  • GeorgeH - Tuesday, March 16, 2010 - link

    I think you've got that backwards. A dual socket motherboard needs 5-series chips, but a 5-series should work in a single socket board just fine. In general it'd be silly to run only one (a 2.66GHz W3520 costs ~$300 while a 2.66GHz X5550 costs ~$1000) but if the cheapest 32nm LGA-1366 chip is a 5-series Xeon it might be worth it. Reply
  • jonup - Wednesday, March 17, 2010 - link

    But you can get E5520 @2.26GHz for $390 and get a faster QPI. Reply
  • greylica - Tuesday, March 16, 2010 - link

    Blender 3D 2.50 in his Alpha 2 Stage supports 64 simultaneous Threads, and it's not hard to make benchmarks, and I am missing Blender 3D benchmarks in every processor launch, what happened with ''Blender 3D Character benchamrks'' ?
    Blender can extract blood from those ''beasts''...
    Reply
  • JohanAnandtech - Wednesday, March 17, 2010 - link

    I have indeed heard more than once that Blender is getting really popular. "Alpha 2" does not sound like the software is very stable. Any suggestion to what kind of scene I should use? The scene choice is very important as the parallel rendering part must be long enough compared to some of serial parts in the process. You can mail me at johan@anandtech.com if you like. I am open to suggestions. Reply
  • MySchizoBuddy - Tuesday, March 16, 2010 - link

    Also add HPC related benchmarks Reply

Log in

Don't have an account? Sign up now