asked on

SQL 2005 Resource Kit and Utilities to measure comparative db performance

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.

MikeWalsh

not that I know of. There is a new addition to the Visual Studio Team Edition Software affectionately named "Data Dude" right now.. that is available as a free download. There are features in there to generate data loads, do unit testing etc. I don't believe it replays a workload, however. I honestly have never heard of DB Hammer myself..

http://blogs.msdn.com/gertd/archive/2006/06/12/628547.aspx

ASKER CERTIFIED SOLUTION

MikeWalsh

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Anthony Perkins

See if this helps:

How to use the SQLIOStress utility to stress a disk subsystem such as SQL Server
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q231619#toc

MikeWalsh

I was going to give him that link but it almost sounded more like he wanted to look at overall db performance not the IO, but good suggestion.

Anthony Perkins

And I suspect you are right. I was about to post the codeproject link, but someone beat me to it :)

MikeWalsh

who did such a thing?? :)