Solved

SQL 2005 Resource Kit and Utilities to measure comparative db  performance

Posted on 2006-06-23
6
982 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
What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

 
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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Join & Write a Comment

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

757 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

20 Experts available now in Live!

Get 1:1 Help Now