July 18, 2001 at 1:52 pm
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.
July 18, 2001 at 2:53 pm
Look on microsofts sql site for the stress tool and load tool. Or, you can pick up the sql server 2000 resource kit.
Wes
July 18, 2001 at 4:09 pm
July 18, 2001 at 6:46 pm
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
July 19, 2001 at 3:39 am
Andy, do you have a URL for this tool (MS Load Simulator)?
Chris Hedgate @ Apptus Technologies (http://www.apptus.se)
July 19, 2001 at 9:05 am
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
July 19, 2001 at 9:29 am
OK. Guess I'll have to look through the CDs then.. It's in there somewhere.
Chris Hedgate @ Apptus Technologies (http://www.apptus.se)
July 19, 2001 at 9:46 am
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy