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
AnandTech Forums Database Test Results
The results are split up into two categories: 2-way and 4-way setups. Remember that the 3.2GHz Potomac based Xeon is only available in 2-way configurations and is thus absent from the 4-way graphs. The labels are as follows: CPU Name Clock Speed/FSB Speed/Cache Size (e.g. Xeon 3.0GHz/400/4MB = Xeon 3.0GHz, 400MHz FSB, 4MB L3 cache). Keep in mind that all Xeons have a 512KB on-die L2 cache, and all Opterons have a 1MB on-die L2 cache (but no L3 cache).
Despite the fact that we're dealing with a pretty hefty database, the Xeon does not benefit from a massive 4MB L3 cache here. For most transactional database applications, the search queries that will be running are small enough to fit inside caches much smaller than 4MB since they are very specific queries to well indexed databases. More general queries however would increase the need for a larger cache.
What we do see is that the Potomac's 533MHz FSB and higher clock speed come in handy and bring the Xeon to within striking distance of the Opteron, but at 2.2GHz the Opteron holds onto a 5% lead.
Once we look at 4-way configurations, the Opteron maintains an 11% performance lead over the fastest Xeon MP.
When looking at write performance, the Opteron once again maintains a small lead in the 2-way performance category.
...but add another 2 processors to all of the systems and the Opteron flexes its muscle once again. It's clear that AMD put together a very scalable design with Opteron and it's paying off.
Facebook
Twitter
RSS
58 Comments
View All Comments
Jason Clark - Wednesday, March 3, 2004 - link
Pumpkin not really..my point is that we used a standard shipping opteron system. I'm not questioning that Opterons support DDR400 or that if you wanted to "tweak" out a server (which is rarely done) that you could. My point is that currently quad opterons are shipping with DDR333 (what we tested). I'm sure (as I said) that down the road ddr400 will be a reality for the boxed/packaged systems but obviously right now it is not. All 4 systems that were shipped to us all came with ddr33 not ddr400.L8r
Jeff7181 - Wednesday, March 3, 2004 - link
I'm surprised nobody has speculated about who the corporation was that helped do the testing.I'll speculate that it was newegg.com =)
Jeff7181 - Wednesday, March 3, 2004 - link
I 2nd #15 motion for pics =)DBBoy - Wednesday, March 3, 2004 - link
Taken from an artilce on the new 4MB L3 products.The new 3-GHz Xeon MP with 4 Mbytes of cache is listed by Intel as available for $3,692 each in quantities of 1,000.
Tessel8 - Wednesday, March 3, 2004 - link
Why do all of the benchmark results page refer to "Potomac" as the 2-way Xeon 3.2GHz processor. This is absolutely not correct (maybe you are refering to Prestonia?).Ex. The results are split up into two categories: 2-way and 4-way setups. Remember that the 3.2GHz Potomac based Xeon is only available in 2-way configurations and is thus absent from the 4-way graphs.
I believe only the last paragraph on the last page is the only one refering to the correct Potomac processor.
Pumpkinierre - Wednesday, March 3, 2004 - link
#30 Jason, Your statement would be in conflict with your previous server comparison article(http://www.anandtech.com/IT/showdoc.html?i=1935&am..."Just recently, the x48 parts were launched, and with them, the Opteron gained support for DDR400 memory. Support for DDR400 has trickled down to all members of the Opteron family, but only certain revisions of the CPUs support DDR400"
I certainly thought they released 4 new DDR400 opterons late last year, covering all configs. At any rate it is the 2way that is in question and you had 2way 533MHz Xeons so, by rights, you should have used opteron 248s as this would be what an customer interested in this configuration would buy. The price of these is half again of the 848 making them even more attractive:
http://www.amd.com/us-en/Corporate/VirtualPressRoo...
You had two 248s in that last server article but again used DDR333. The photo on Pg 2 showed one of the opterons as an "AM" revision which, you state in the article, qualifies for DDR400 support. Of course, if these cpus, DDR400 Reg. modules or enabled Mobo were not on hand then it cant be helped and as you say the DDR333 setup still shows the Xeon memory structural problem.
Sante
TrogdorJW - Tuesday, March 2, 2004 - link
Wow... given that the 533 FSB on the 2-way Xeons easily makes up for the difference in cache size, I'm amazed that Intel hasn't actually validated an 800 FSB Xeon solution. Then again, Intel is *SO* cautious with introducing advancements in technology, especially in the server/enterprise markets. Not only would they have to validate the faster CPU, but the motherboard and chipset validation would probably take them a year at least. (Who knows... they might be working on this as we speak.) Too bad the P4EE aren't dual-CPU capable (I think) - that would be interesting to see benchmarks. Not that any real corporation would dare to go that route, but still, interesting.It will be interesting to see what happens with the Nocoma cores (and later Potomac). The 1 MB L2 cache can help out in desktop applications and more or less overcome the longer pipeline, but on Xeons where you're already running 2 MB L3 cache, I don't know that it will be as useful. Then again, the 800 FSB will probably more than make up for the deeper pipeline.
Needless to say, Intel definitely has some work to do. I'm waiting for them to migrate the Pentium M (P6 core with improvements) back to the desktop. Heheheh....
lneves - Tuesday, March 2, 2004 - link
Can you guys share the "SQL Loader" benchmark tool and the scripts used?Thanks.
Jason Clark - Tuesday, March 2, 2004 - link
Grayswan, each proc had 1 gb as that is how it has to be configured.More thoughts on DDR400. After doing a bit more reading I've confirmed that most all quad opterons ship with ddr333 so our tests conformed to what was available at the time of testing. Testing something that isn't a standard shipping configuration doesn't help people making a buying decision now. Most all quad opterons won't be hand built by an organization, they will be ordered as complete systems. Maybe later on this year we'll see a shift to ddr 400 and we can run some numbers.
Examples:
http://www.swt.com/qo.html
http://www.appro.com/product/server_4144h_2.asp
Grayswan - Tuesday, March 2, 2004 - link
What was the memory organization on the opterons? All memory on 1 proc? 2 modules on each proc? Also the 4-way opteron diagrom on P.3 shows each proc only using 2 interconnects. I believe all 3 are used so the diagram should be "crossbar"ish.