Solved

SQL 2005 Resource Kit and Utilities to measure comparative db  performance

Posted on 2006-06-23
6
984 Views
Last Modified: 2008-01-09
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.
0
Comment
Question by:rzup
  • 4
  • 2
6 Comments
 
LVL 13

Expert Comment

by:MikeWalsh
ID: 16973640
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
0
 
LVL 13

Accepted Solution

by:
MikeWalsh earned 250 total points
ID: 16973655
http://www.codeproject.com/vb/net/DBstressUtil.asp

that is a tool similar to data hammer according to some blogs. It is still designed for SS2K.. But it may work for 2k5, and if not, you should be able to modify it as the code is available. It is coded with the VB.NET framework.
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 16973667
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
0
Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

 
LVL 13

Expert Comment

by:MikeWalsh
ID: 16973675
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.
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 16973685
And I suspect you are right.  I was about to post the codeproject link, but someone beat me to it :)
0
 
LVL 13

Expert Comment

by:MikeWalsh
ID: 16973690
who did such a thing?? :)
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

919 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now