ABOUT BENCH FORUMS PODCAST LOGIN REGISTER
PC Components▼
Smartphones & tablets▼
Systems▼
ENTERPRISE & IT
GUIDES▼
DEALS

AMD's dual core Opteron & Athlon 64 X2 - Server/Desktop Performance Preview

 by Anand Lal Shimpi, Jason Clark & Ross Whitehead on April 21, 2005 9:25 AM EST
144 Comments | Add A Comment
144 Comments

SQL Stress Tool Benchmark

Our first benchmark was custom-written in .NET, using ADO.NET to connect to the database. The AnandTech Forums database, which is over 14GB in size at the time of the benchmark, was used as the source database. We'll dub this benchmark tool "SQL Stress Tool" for the purposes of discussing what it does. We have done some updates to the tool since we first used it; it now supports Oracle, and MySQL. We also adjusted the test time for this test and future tests to 20 minutes. The reason for this was to ensure that we used as much memory as possible for future planned 64 bit tests.


Click to enlarge.

SQL Stress allows us to specify the following: an XML based workload file for the test, how long the test should run, and how many threads it should use in which to load the database. The XML workload file contains queries that we want executed against the database, and some random ID generator queries that populate a memory resident array with ID's to be used in conjunction with our workload queries. The purpose of using random ID's is to keep the test as real-world as possible by selecting random data. This test should give us a lot of room for growth, as the workload can be whatever we want in future tests.

Example workload:


    Select1
    select count(iuserid) as usercount from ftdb_forumusers where iforumid = 1


    Select2
    select count(u.iuserid) as currusercount from ftdb_users u,ftdb_forumusers fu where fu.iforumid = 1 and u.iuserid = fu.iuserid and dtlastvisiteddate > '[q]qGetLastVisitDate[/q]'


Example Random ID Generator:


    qGetLastVisitDate
    select dtlastvisiteddate,newid() as ldate from ftdb_users where dtlastvisiteddate is not null order by ldate


The workload used for the test was based on every day use of the Forums, which are running FuseTalk. We took the most popular queries and put them in the workload. Functions, such as reading threads and messages, getting user information, inserting threads and messages, and reading private messages, were in the spotlight. Each reiteration of the test was run for 20 minutes, with the first being from a cold boot. SQL was restarted in-between each test that was run consecutively.

The importance of this test is that it is as real world as you can get; for us, the performance in this test directly influences what upgrade decisions we make for our own IT infrastructure.

Web Tests - FuseTalk .NET SQL Stress Results
PRINT THIS ARTICLE
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.
Copyright © 2024. All rights reserved.
BENCH
TOPICS
FOLLOW
ABOUT

Log in

Don't have an account? Sign up now