SQL Server load test tool

• ocolakoglu

  SSC Enthusiast

  Points: 147

  More actions

  September 16, 2010 at 2:19 am

  #226362

  Hi I need a good and effective load test tool running from trace file. For example I took a trace file into sql table when I select it as **SELECT DISTINCT SPID FROM TRCTABLE** It returns about 200 rows. So that for half hour there was at least 200 connections in the our productin server. And I want to simulate it on our new free server. How can i do this. Could you suggest a software or script for me?

• Adiga

  One Orange Chip

  Points: 27284

  More actions

  September 16, 2010 at 5:04 am

  #1222060

  Here is an example. Create a new batch file say loadtest.bat which has the following code in it

  sqlcmd -SServerName -E -Q "sp_who2"

  loadtest.bat

  This will run sp_who2 continuously until you stop the batch file

  Pradeep Adiga
  Blog: sqldbadiaries.com
  Twitter: @pradeepadiga