AMD's 12-core "Magny-Cours" Opteron 6174 vs. Intel's 6-core Xeon
by Johan De Gelas on March 29, 2010 12:00 AM EST- Posted in
- IT Computing
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).
Almost all of the load on the database are selects (99%), about 5% of them are stored procedures. Network traffic averages 6.5MB/s and peaks at 14MB/s. So our Gigabit network 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.
We now use an new even 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.
Pretty amazing performance here. And while AMD gets a pat on the back, it is the hard working people of Microsoft SQL Server team we should send our kudos to. Our calculations show that SQL Server adds about 80% of performance when adding an extra 12 cores, which is simply awesome scaling. The result of this scaling is that for once, you can notice which CPUs have real cores vs. ones that have virtual (Hyper Threading) cores: the 12-core Opteron 6174 outperforms the best Xeon by 20%. The people with transaction databases should go for the Intel CPUs, while the data miners should consider the latest Opteron. The architectures that AMD and Intel have chosen are complete opposites, and the result is that the differences between the different software categories are very dramatic. Profile your software before you make a choice! It has never been so important.
Facebook
Twitter
RSS
58 Comments
View All Comments
Cogman - Tuesday, March 30, 2010 - link
It should be noted that newer nehelam based processors have specific AES encryption instructions. The benchmark where the xeon blows everything out of the water is likely utilizing that instruction set (though, AFAIK not many real-world applications do)Hector1 - Tuesday, March 30, 2010 - link
I read that Intel is expected to launch the 8-core Nehalem EX today. It'll be interesting to compare it against the 12-core Magny Cours. Both are on a 45nm process.spoman - Tuesday, March 30, 2010 - link
You stated "... that kind of bandwidth is not attainable, not even in theory because the next link in the chain, the Northbridge ...".How does the Northbridge affect memory BW if the memory is connected directly to the processor?
JohanAnandtech - Wednesday, March 31, 2010 - link
Depending on your definition, the nortbridge is in the CPU. AMD uses "northbride" in its own slides to refer to the part where the memory controller etc. resides.Pari_Rajaram - Tuesday, March 30, 2010 - link
Why don't you add STREAM and LINPACK to your benchmark suites? These are very important benchmarks for HPC.JohanAnandtech - Wednesday, March 31, 2010 - link
Stream... in the review.piooreq - Wednesday, March 31, 2010 - link
Hi Johan,For last few days I did several tests with Swingbench CC with similar database configuration but I achieved a bit different results, I’m just wondering what exactly settings you put for CC test itself. I mean about when you generate schema and data for that test? Thanks for answer.
JohanAnandtech - Thursday, April 1, 2010 - link
Your question is not completely clear to me. What is the info you would like? You can e-mail if you like at johanATthiswebsitePointcomzarjad - Wednesday, March 31, 2010 - link
Can't figure out if hyperthreading were enabled on Intels. Particularly interested in virtualization benchmark with hyperthreading both enabled and disabled. Also of interest would be an Office benchmark with a bunch of small VMs (1.5 to 2GB) to simulate VDI configuration.JohanAnandtech - Thursday, April 1, 2010 - link
Hyperthreading is always on. But we will follow up on that. A VDI based hypervisor tests is however not immediately on the horizon. The people of the VRC project might do that though. Google on the VRC project.