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
Fraggster - Tuesday, March 2, 2004 - link
intel=pwnd again :)Jason Clark - Tuesday, March 2, 2004 - link
64Bit tests are next on our agenda, once there is an Extended 64bit version of SQL Server.... :) We're looking into other avenues as well.Andreas, windows 2003 enterprise is what we used.
fukka - Tuesday, March 2, 2004 - link
Would the Opterons gain any advantage using a 64bit OS (aka Linux) and a database that is much bigger than 4GB in size?That would be interesting to see, but I suppose the IA32e will address that advantage...
andreasl - Tuesday, March 2, 2004 - link
Hey Anand have you thought about moving to Server 2003 instead of running 2000? And any chance of seeing 64-bit results anytime soon? (does a 64-bit version of your app even exist?)christophergorge - Tuesday, March 2, 2004 - link
Opteron only works with ECC registered memory. They only come up to DDR333.raptor666 - Tuesday, March 2, 2004 - link
Maybe because 4 way boards might not support it.Just a guess but honestly i'm not sure.
Peter
tolgae - Tuesday, March 2, 2004 - link
Stupid question probably but why didn't you use DDR400 on the Opteron?CRAMITPAL - Tuesday, March 2, 2004 - link
No surprises here... Anyone with a clue has known for a year that Opteron/A64 is a far superior architecture to anything Intel bulds, sells, or plans to produce in the next two years.