AMD Opteron vs. Intel Xeon: Database Performance Shootout
by Anand Lal Shimpi, Jason Clark & Ross Whitehead on March 2, 2004 2:11 AM EST- Posted in
- IT Computing
Final Words
The 533MHz FSB 2MB L3 Prestonia based Xeon manages to help Intel tremendously in keeping competitive with the Opteron. In fact, under heavy enough workloads there is virtually no performance difference between a 3.2GHz Xeon and a 2.2GHz Opteron (x48). It isn't until you move to 4-way configurations that AMD's platform architecture begins to flex its muscle. That being said, Intel has done an incredible job of keeping up performance wise in 2-way configurations; we have a much better showing here than we did in the web server test.
Interestingly enough, while the new Gallatin Xeon MPs have a massive 4MB L3 cache, most of that cache will end up being used to keep traffic off of the bandwidth starved 400MHz FSB. The performance gap between the Opteron 848 and the Xeon MP is amplified significantly once you move to a 4-way setup; the Xeon's shared bus just can't cut it anymore, not at 400MHz. AMD's point-to-point Hyper Transport implementation helps extend their performance advantage significantly. An 8-way Opteron vs. Xeon comparison would not be pretty.
In a matter of months, Intel will begin transitioning their Xeon line to 90nm cores - more specifically Nocona (the replacement for the current Prestonia Xeon). The 90nm Xeons will be Prescott derived, which means they get all of the bittersweet changes that went into Prescott. At the same time, this next generation of Xeon processors will enable Intel's 64-bit IA-32e instruction set (read: x86-64). From a performance perspective we would expect the 90nm cores to perform noticeably worse than the current Xeons on a clock for clock basis, but it seems that Intel is avoiding an embarrassing launch by releasing the first Nocona based Xeons at 3.6GHz. With Nocona, Intel will also introduce the 800MHz FSB to the Xeon family - definitely a much needed step in the right direction. For 4-way servers, Intel will have to wait a bit longer; it won't be until the first quarter of 2005 before 64-bit extensions make their way into the Xeon MP processors using the 90nm Potomac core.
The comparison we've made here is a very important one; it identifies Intel's strengths and their weaknesses with Xeon, and it crowns Opteron a clear multiprocessor winner. An area that we didn't touch on is cost, which is where AMD truly shines. The Opteron 848 processors we tested are around 1/2 the price of Intel's 2MB L3 Xeon MPs and we have not seen retail data on how expensive the 4MB parts will be.
In a 4-way configuration AMD's Opteron cannot be beat, and thus it is our choice for the basis for our new Forums database server. We'll be documenting that upgrade in a separate article so stay tuned.
58 Comments
View All Comments
Blackbrrd - Wednesday, March 3, 2004 - link
Hmm... the site below has some info about Numa (non unified memory architecture), and it looks like the os you're using isn't Numa enabled... Is this correct? Is there any real world benefit from Numa with Opteron?http://www.gamepc.com/labs/view_content.asp?id=opt...
zarjad - Wednesday, March 3, 2004 - link
Could you speculate which way the advantage should be going in a BI benchmark (say TPC-H type of a test)? These are long running queries with gigabytes size tables.Jason Clark - Wednesday, March 3, 2004 - link
We started playing around with a couple of mysql benchmarks a few weeks ago namely OSDB and some new multithreaded benchmarks from MySQL themselves. We're hoping to get some valid tests that produce real results in the future.Cheers.
Jason Clark - Wednesday, March 3, 2004 - link
In fact we did some recent testing to start out 64bit linux testing and mysql 4.0.17 on suse 64 had a segmentation fault starting <WINK> known issue for mysql as well... <WINK> <WINK>Jason Clark - Wednesday, March 3, 2004 - link
Steveoc, it hardly runs like a dog. Let's not turn this into a one sided os war :) The test make sense as they are, but a 64bit article is on the books for later. We've already been playing around with Suse 64bit and some others and whether you agree or not 64bit is still immature, period full stop. Support is there but it has some maturing to do.steveoc - Wednesday, March 3, 2004 - link
All these tests show is that Opteron, running Windows, runs like a Dog. As if we couldnt predict that result already ...The tests will only make sense once you are running 64bit linux. In fact, Id love to see a test of Dual Xeon + Win2003 + MSSQL vs Dual Opteron + 64bit Gentoo + 64bit MySQL .. that would be very interesting indeed.
For anyone out there claiming that '64bit software has a looong way to go', that is only true for Windows. Unix (and Linux) have been running 64bit for a long time now, and the AMD64 has very good support under Linux.
dweigert - Wednesday, March 3, 2004 - link
Seeing the difference whether NUMA us used or not would be *VERY* interesting. Also comparing against other NUMA aware OS's (Linux 2.63 or better kernel, or whatever) would be a good test too.hirschma - Wednesday, March 3, 2004 - link
#25 - Seems that it is not for sale to the general public, not that I could find. If anyone knows where/how to get one, please let me know.I have an application that is quite expensive and is licensed by the box, no matter how many CPUs it has ;) I'm guessing that building a low-end quad would give me more throughput per $$ than a second license/second box.
Jonathan
Jason Clark - Wednesday, March 3, 2004 - link
We're also looking at some 64bit .NET benchmarks as we're real close to having a real-world application that we can hammer.Jason Clark - Wednesday, March 3, 2004 - link
An interesting article would be the effect of NUMA on enterprise level applications. GamePC did a bit of a write up on it, but it was limited to desktop and synthetic benchmarks. Would any of you be interested in seeing the effects of NUMA on and off on the sql tests?