September 16, 2010 at 2:19 am
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?
September 16, 2010 at 5:04 am
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
Viewing 2 posts - 1 through 2 (of 2 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