SQL 2005 Resource Kit and Utilities to measure comparative db performance
Posted on 2006-06-23
SQL2000 had a test utility called DB Hammer in the 2000 Resource Kit. I can't find a Resource Kit for SQL 2005 on the msdn or any microsoft site, and am wondering two things:
Is there a resource kit for 2005? I tried to use the 2000 kit's DB Hammer utility on 2005, and it errors out.
Is there a good, generic test utility that I can use to create a test db and measure a simulated load on a 2005 SQL db, so I can compare the results across several servers running SQL 2005 (I want to compare hyperthreading vs. 64-bit vs. Opteron vs. Intel and so on).
Thanks for any ideas on this.