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

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

  • patrick0 - Sunday, April 24, 2005 - link

    If they would have the dual-core in stores in June, I would buy one, but this isn't the case, so I'll buy San-Diego 4000+.
    I'll upgrade when quad-core will be out.

  • Barneyk - Sunday, April 24, 2005 - link

    oh, you cant edit your comments...

    Anyway, im really excited about this development of computing, not having good multitasking ability feels so outdated, i've been crying about that for years, and fianlly its here...
    Well, almost, and its probably another year before i can afford it, but still... :)

  • Barneyk - Sunday, April 24, 2005 - link

    test

  • jvarszegi - Sunday, April 24, 2005 - link

    Again, the lack of technical superiority of AT's "experts" is obvious. On SQL Server, you're not supposed to prepend stored-procedure names with "sp_", as it introduces a performance penalty. This is basic knowledge. Some have remarked before on how their .NET "experts" code like, um, transplanted ColdFusion "experts". :)

  • Visual - Sunday, April 24, 2005 - link

    a minor error: on page 12 right above the graph it says "The Dual Opteron 252's lead by 19% over the closest Xeon, which was the Quad Xeon 3.6 GHz 667MHz FSB" but the slowest xeon is the 3.3 GHz one.

  • mechBgon - Saturday, April 23, 2005 - link

    Zebo... hehe, yep :D

  • justly - Friday, April 22, 2005 - link

    An outstanding article about AMDs duel core, just what I would expect from Anandtech (to bad I had to go to techreport.com to read it).

  • Zebo - Friday, April 22, 2005 - link

    Hahaha makes Chetta's drool: Looks just like you MECH.:)

  • MACKTEK - Friday, April 22, 2005 - link

    I appreciate the article but am disappointed by the misleading title... AMD's dual core Opteron & Athlon 64 X2 - Server/Desktop Performance Preview. The 939 is not equal to 940. Also, the article clearly says
    COMPARE ATHLON 64 X2... right on the 1st page. In fact the article does not admit to "not having a real x2" until page 13. I love reading anandtech's articles and visit frequently... Perhaps a better title would have been... Preview of Athlon64 X2 using an Opteron CPU.

  • mechBgon - Friday, April 22, 2005 - link

    http://pics.bbzzdd.com/users/mechBgon/drool.jpg



    #82 says "and corporate PCs could work perfectly and more with a K5-K6/P2-P3."

    Ahhh, this again. You obviously haven't worked with a fully-armed installation of McAfee VirusScan Enterprise 8.0i. *evil grin* Hope you enjoyed your stay in 1999... welcome to 2005.

    ;)
Copyright © 2024. All rights reserved.
BENCH
TOPICS
FOLLOW
ABOUT

Log in

Don't have an account? Sign up now