Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

SQL 2005 Resource Kit and Utilities to measure comparative db  performance

Posted on 2006-06-23
6
Medium Priority
?
995 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 750 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
Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

 
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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Suggested Courses

810 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