Executing Multiple Threads to Create a Load

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738127

  More actions

  August 11, 2016 at 12:14 am

  #328984

  Comments posted to this topic are about the item Executing Multiple Threads to Create a Load

• Alex Friedman

  Right there with Babe

  Points: 755

  More actions

  August 11, 2016 at 1:08 am

  #1894933

  SQLQueryStress

• abbotn

  Grasshopper

  Points: 13

  More actions

  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

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  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

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738127

  More actions

  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.

• TheSQLGuru

  SSC Guru

  Points: 134017

  More actions

  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