Performance and Stress tests

Hi out there
I am trying to create a uniform test-environment which I can move from one
hw platform to another. I have found ostress.exe and read80trace.exe as a
usefull tool for this. Are there some out there which has written some either
stress-scripts for these tools to stress a sql-database, so that I can see
how to do it (sorry to admit it but I am a wizard into sql)
regards /thomas iwang
Hi
MS has some tools, follow the link from:
http://msmvps.com/epprecht/archive/2.../24/10591.aspx
Regards
Mike
"Thomas Iwang" wrote:

> Hi out there
> I am trying to create a uniform test-environment which I can move from one
> hw platform to another. I have found ostress.exe and read80trace.exe as a
> usefull tool for this. Are there some out there which has written some either
> stress-scripts for these tools to stress a sql-database, so that I can see
> how to do it (sorry to admit it but I am a wizard into sql)
> regards /thomas iwang
|||Hi,
If you want to stress io subsystem sqliostress is a nice stress tool. First
you don't need to install sql server to use sqliostress, and if you have
problems with your io subsytem you can catch them before going into
production. (We catch some serious problems with the fibre channel adapter
cards etc.. thanks to sqliostress)
If you like to stress test your application, we use ACT which is available
with Visual Studio if i'm not wrong..
And there used to be a tool in resource kit which is called Database Hammer..
Hope this helps..
"Thomas Iwang" wrote:

> Hi out there
> I am trying to create a uniform test-environment which I can move from one
> hw platform to another. I have found ostress.exe and read80trace.exe as a
> usefull tool for this. Are there some out there which has written some either
> stress-scripts for these tools to stress a sql-database, so that I can see
> how to do it (sorry to admit it but I am a wizard into sql)
> regards /thomas iwang