Data Warehouse Test

We are always looking to improve the quality of our reviews and as a result, we have added a new Stress Test to our suite.

This "Data Warehouse" test is focused on large record sets with plenty of aggregation. This test is based on a system that we developed to track and manage Request statistics for www.AnandTech.com and Forums.AnandTech.com. It tracks statistics like Requests/Hour, Requests/Hour/IP Address, Unique IP Addresses/Hour, Unique Users/Hour, Daily Browser stats, etc. These stats are further summarized by site, i.e. www or Forums.

As with the other Stress Tests, each test was repeated three times and the average between the three tests was used. For this Data Warehouse Stress Test, we defined a quantity of work to complete and measured how long each platform required to process the workload.

So, to ensure that IO was not the bottleneck, each test was started with a database, including tempdb, which had already been expanded so that autogrow activity did not occur during the test. During the execution of the tests, there were no applications running on the server or monitoring software. Task Manager, Profiler, and Performance Monitor were used when establishing the baseline for the test, but never during execution of the tests.

At the beginning of each platform, the server was rebooted to ensure a clean and consistent environment. The database was always copied to the 8 disk RAID 0 array with no other files present to ensure that file placement and fragmentation were consistent between runs. In between each of the three tests, the database was deleted, the original database was copied again to the array, and SQL Server was restarted.

There is no "client" required for this test. The workload is initiated by a stored procedure call from Query Analyzer.

Order Entry Results Data Warehouse Results
Comments Locked

144 Comments

View All Comments

  • ceefka - Thursday, April 21, 2005 - link

    So, would an nForce 3 250 board work with an A64 X2?
  • smn198 - Thursday, April 21, 2005 - link

    #4 "I find it strange why AMD did not release <2.2GHz A64 X2s? Maybe due to manufacturing issues?"

    When you make a dual core CPU, a defect on one of them makes the whole lot worthless. I believe that to try and reduce this, they can increase yield by producing lower clocked parts
  • L3p3rM355i4h - Thursday, April 21, 2005 - link

    #9 you're dreamin' Theres no way that AMD can sell a 1.8ghz chip for sub-$200 when a frickin' venice is retailing for $179. A 1.8ghz chip would be upper $300 to lower $400s.

    But, damn the "X2" performs nicely. Just think, with a stable, higher performing motherboard with decent timings how much better it would get.
  • Shinei - Thursday, April 21, 2005 - link

    Nice, dual-core. AMD's going to be hurt badly by the lack of volume on their X2 units, though, considering that Intel's got the money to post minor losses on each chip sold just to regain their marketshare. I'm surprised AMD hasn't tapped IBM to give them one or two 65nm fabs to prepare for the A64X2 launch later this year...
  • AnnihilatorX - Thursday, April 21, 2005 - link

    hm hope fab36 would increaswe production capacity of AMD and lower the cost down a bit
  • blckgrffn - Thursday, April 21, 2005 - link

    Awesome...I wish we could have seen a 4 socket 8 processor system rocking out with those four way xeons though, that would really illustrates some differences ;)

    I agree with the previous sentiment on the x2's, I hope they bring out a sub $200 1.8 ghz or so model. I will be sticking this in my desktop box, not my gaming box, so if they can't bring anything out under $200 I will probably have to go with Intel. Boo for that ;)

    Nat
  • Zebo - Thursday, April 21, 2005 - link

    It's a wonderful article Anand, always love yours.. very in-depth But you're forgetting mem timings??? Arr.:)
  • Zebo - Thursday, April 21, 2005 - link

    Slobber:P
  • blackbrrd - Thursday, April 21, 2005 - link

    #4 AMD probably wants you to buy their single core cpus instead, as they are much cheaper to produce and easier to produce in quantities. AMD would probably have problems delievering a lower cost dual core in quantities .

    Who doesn't drewl for a A64 X2 after seeing this review??? I certainly do.

    The dual core intel wouldn't be so bad either, except for the amount of heat it produces off.
  • filterxg - Thursday, April 21, 2005 - link

    Nice article. AMD has obviously awoken a sleeping giant, and Intel is fighting back on the pricing front. Hopefully the gamble that AMD single cores can hold their own versus Intel Duallies is true on the mid-low end (at least for the near future). I won't be buying an Intel chip anytime soon (unless I need a laptop).

    Either way I figure I got 2.5 years before I need a dualcore, and by then who knows. So bravo to both companies for this innovation.

Log in

Don't have an account? Sign up now