August 11, 2016 at 12:14 am
Comments posted to this topic are about the item Executing Multiple Threads to Create a Load
August 11, 2016 at 1:08 am
SQLQueryStress
August 11, 2016 at 6:09 am
C:\>FOR /?
C:\>FOR /L %a IN (1,1,10) DO start sqlcmd -S . -i contactquery.sql -U Redgate -P x
August 11, 2016 at 6:28 am
I use SQLQueryStress too, have always found it useful to run a simple load test to reveal issues. Getting the workload right in terms of parameters is the hard part.
August 11, 2016 at 9:13 am
Thanks, lots of ways to do this.
I have tended to quickly mock things up for demos and short tests with a few CMD files. It's lightweight, nothing to install or find, and works.
I've used SQLQueryStress, and it's fine as well.
August 13, 2016 at 7:10 am
Thanks for the pointer for the tool I wasn't aware of Steve. I like the ability to put your queries in different windows (with different connections even), and some other features. And since I have the source code I can extend/improve to my liking.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply