Data Warehouse Results

This test is different than our other tests as there are no parallel queries being executed. On the other hand, the query optimizer is able to use parallel execution and utilize multiple processors for the same query. This does not lead to the same CPU load as parallel queries, but does demonstrate a measurable difference in execution time.

In these tests, the datasets are mostly 100,000+ records and are many times larger than the L2 and L3 cache; thus, the additional cache is of no benefit. It is all about the number of instructions that can be completed in a given period. The ability to move data quickly in and out of the CPU are the characteristics of a winner in this test.
  • There is a 30% spread in results between the fastest and slowest platform. Yet again, it is proof that you do not have to be CPU bound to recognize a performance gain from a hardware upgrade.
  • The Dual Opteron 252's lead by 19% over the closest Xeon, which was the Quad Xeon 3.6 GHz 667MHz FSB
  • The Quad Xeon 3.6 GHz 667MHz outperformed the Dual 3.6GHz 800MHz FSB by 8%.

Datawarehouse Test

Data Warehouse Results Dual Core Desktop Performance: AMD’s Athlon 64 X2 4400+
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.

    ;)

Log in

Don't have an account? Sign up now