Solved

SQL 2005 Resource Kit and Utilities to measure comparative db  performance

Posted on 2006-06-23
6
987 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
Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

 
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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
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.

808 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