SQL Stress Results

The SQL Stress results have changed somewhat from some of our earlier articles using this tool. We did a revamp of the tool itself, which is more performant on high volume queries. Also, we lengthened the test time to 20 minutes and changed the queries around some to reflect our current FuseTalk version.

The Quad Xeon prevailed in this test, due to the small size of the data being manipulated by the CPU. The Xeon doesn't have to go off the processor for data nearly as often as it does in our Heavy workload tests. The Quad Xeon 3.6 with 1MB of L2 squeaked by the Dual Core 875 with a 5% margin, while the 3.3GHz with 8MB of L3 managed nearly a 10% lead. Obviously, with a smaller data set, we're not fully utilizing the 8MB of L3 that the Potomac Xeons offer.

SQL Stress Tool

SQL Stress Tool

SQL Stress Tool Benchmark "Order Entry" Stress Test: Measuring Enterprise Class Performance
Comments Locked

144 Comments

View All Comments

  • morcegovermelho - Thursday, April 21, 2005 - link

    page 3 "For example, the Opteron 252 and Opteron 852 both run at 2.6GHz, but the 252 is for use in up to 2-way configurations, while the 852 is certified for use in 4- and 8-way configurations. The two chips are identical; it's just that one has been run through additional validation and costs a lot more. "
    I thought that they had different number of HyperTransport (HT) links:
    152 - 1 HT
    252 - 2 HT
    852 - 3 HT
    I thought that was the reason why it was impossible to use two 152s in a two-way motherboard.
    Maybe i'm wrong.
  • faboloso112 - Thursday, April 21, 2005 - link

    great article
  • fungmak - Thursday, April 21, 2005 - link

    #50
    Dual 875s have 4 cores
  • stmok - Thursday, April 21, 2005 - link

    I have waited SOOOOO long! Finally, a reason to dump my dual PIII setups. Next stop, Athlon64 X2!
  • jediknight - Thursday, April 21, 2005 - link

    Can someone explain the huge performance difference between the dual Operaon 252s (2.6GHz) and the dual Opteron 875 (2.2GHz)?

    Since:
    "The two chips are identical; it's just that one has been run through additional validation and costs a lot more"

    I would expect the 252s, running at 400MHz more, would outperform the 875s. Can someone explain this (large) discrepency?
  • snedzad - Thursday, April 21, 2005 - link

    Yes. That's gonna be a four proc-machine. Terrific.

    I am really astonished about whole AMD K8 architecture. And K9 should be 4-core processor architecture.

    Can't wait.

    But, I still won't get a rid of my AX2600 machine.
  • Griswold - Thursday, April 21, 2005 - link

    Ah the brilliant KillerBob.

    Anand used plenty of real world apps for the multitask benchmarks.

    How much more real world testing would you want to go with your (pointless) whining?

  • GoatHerderEd - Thursday, April 21, 2005 - link

    Why is their stock price at a 6 month low? I hope this pulls it up a bit. It would be a shame if they don’t start making a profit.
  • suryad - Thursday, April 21, 2005 - link

    I just am astounded at the performance these first versions of dual core processing that is being presented to us...WOW...couple that with a well written 64 bit OS and it will be even more smoking!! I think AMD did a job extremely well done and I am glad that they are being aggressive in keeping their pockets full with the prices of their chips. I personally dont think that would stop me from buying their processors. I would wait for the FX to become dual core though. A 3 ghz dual core FX would rock so bad!!!

    Also one more thing...so the Tyan mobo holds 2 procs correct? So if we stuck a dual core in 1 socket and another in the other sock...that makes it a 4 proc machine then right?!!
  • bldckstark - Thursday, April 21, 2005 - link

    Thanks for the double post KillerBob. Your statements are as intelligent as your ability to use a keyboard.

Log in

Don't have an account? Sign up now