Stress Test Database Server
-
Can anyone point me to a good tool that will push a database server to maximum use? We want to push the server to maximum level, then fail it over to the other side of the cluster to make sure the passive side can handle the same load. We are concerned that the two sides of the cluster are different types of servers.
-
There is a tool call SQL Load Simulator (or something close to that) on the BORK Resource Kit, lets you run a script on a lot of concurrent threads. Great way to pound a machine.
Andy
-
Where can one find the BORK resource kit?
-
There is a tool called the "Database Hammer" in the SQL Server 2000 Resource Kit. I've never used it, but I've done some reading about it recently and it sounds like it might be just what you need. Best of luck.
-
BORK = Back Office Resource Kit. The SQL Load Tool came on a CD with BORK 4.5. Database Hammer is a VB app that can be customized with the SQL 2K Resource Kit. I've not played around too much with Database Hammer as I've not had much need to customize nor to insert 10 million rows of random data, but I agree with Andy, SQL Load Tool is pretty good at stressing your DB server with concurrent threads. And yes, I've brought a robust server to its knees with it. That's always fun!
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley -
I am trying to run Database Hammer from the Sql Server 2000 Resource Kit CD.
When I try to run Loadmaster.exe, I get the pop-up screen. When I enter the fields and press start, I get the following error.
Run Time error
Automation error -2147024894 (80070002)
The system cannot find the file specified.
anyone have any ideas
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply