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 new 2MB L2 Xeon part did quite well here, churning out a 7% gain over its 1MB counterpart. The Opteron 252 gained its usual 7% for its clock increase of 200MHz. There was no gain from the 1GHz HT link support as we discussed in our Test Hardware configuration on Page 2. Overall, the new Xeon 2MB part was the "hands down" winner for this test with a 13% lead over the Opteron 252, thanks to its 1MB cache boost.

Total queries executed

The number of queries that were executed throughout the duration of the test.

Queries per second

An average of how many queries per second were executed throughout the duration of the test.

SQL Stress Tool

SQL Stress Tool


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

97 Comments

View All Comments

  • danidentity - Monday, February 14, 2005 - link

    Jason, I hope you're ready for about 5 pages of comments pointing out the flaws in your testing methodology and another 5 pages demanding you re-do all the tests because the Opteron didn't destroy the Xeon.

    Fair warning. ;)
  • Jason Clark - Monday, February 14, 2005 - link

    Tiamat, yep corrected. Thanks
  • Tiamat - Monday, February 14, 2005 - link

    "Dual core Opterons will be socket compatible with existing 950 pin sockets that support 90nm (95W/80A)."

    Correct me if I am incorrect, did you mean 940 pin? If not, I have not seen any 950 pin sockets on the market...
  • Jason Clark - Monday, February 14, 2005 - link

    Aileur, we'll get right on it.
  • Jason Clark - Monday, February 14, 2005 - link

    They are coming soon :) Derek Wilson is going to deliver those.
  • Aileur - Monday, February 14, 2005 - link

    Im afraid youre gonna have to redo this whole article since the opteron doesnt wipe the floor with the xeon, and this is unacceptable.
  • Carfax - Monday, February 14, 2005 - link

    Can you please do some Workstation benchmarks?

    It is rumored that AMD enhanced the SSE2 units aswell as added SSE3 support, and I want to see if it's true.

Log in

Don't have an account? Sign up now