Post reply

Executing Multiple Threads to Create a Load

  • August 11, 2016 at 1:08 am

    #1894933

    SQLQueryStress

  • August 11, 2016 at 6:09 am

    #1894971

    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

    #1894974

    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.

    Andy
    Connect with me on LinkedIn

  • August 11, 2016 at 9:13 am

    #1895021

    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

    #1895322

    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 5 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply