Load Testing Database
-
How can I load test a database? Is there a tool that can simulate thousands of transactions at once? I want to see the effects on replication.
-
Look on microsofts sql site for the stress tool and load tool. Or, you can pick up the sql server 2000 resource kit.
Wes
-
If you have the $$, Quest Software makes a tool for stress testing.
Steve Jones
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com -
I've used the MS Load Simulator tool - it lets you run a script on a bunch of different threads from the same machine, variable interval and #active threads. We used this last year to check a key query - didnt take long to see that with concurrent users it wasnt pretty.
I have not used anything else - we have an app where I work that we would like to know how many concurrent users the box will support, but getting a realistic test seems pretty difficult. If anyone has used the Quest product I'd be interested in hearing about it.
Andy
-
Andy, do you have a URL for this tool (MS Load Simulator)?
Chris Hedgate @ Apptus Technologies (http://www.apptus.se)
-
It is in the Backoffice Resource Kit (BORK) 4.5. I dont know if its available as a general download - if you're an MSDN subscriber you should be able to get it.
Andy
-
OK. Guess I'll have to look through the CDs then.. It's in there somewhere.
Chris Hedgate @ Apptus Technologies (http://www.apptus.se)
-
It also comes with the SQL Server resources kit book. You can also use DataTech's product to load databases with meaningful data. I prefer it over the Quest one.
Brian Knight
http://www.sqlservercentral.com/columnists/bknight
Brian Knight
Free SQL Server Training Webinars
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply