August 26, 2013 at 2:55 pm
My goal is to run a script in multiple concurrent sessions on the same db, today i can do that in a not-so neat way using while loop. I was wondering if there a tool which will just take my script as a input and just throw the execution timings in a table or somewhere?
August 27, 2013 at 6:50 am
You can use the free RML utilities by microsoft to perfom this very action
http://support.microsoft.com/kb/944837
Not the easiest apps to use but very effective.
MCITP SQL 2005, MCSA SQL 2012
August 27, 2013 at 7:43 am
http://www.datamanipulation.net/sqlquerystress/ --Adam Machanic's, quite solid and well used
tpcc/h
http://hammerora.sourceforge.net/
dvdstore
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
August 28, 2013 at 9:47 pm
RTaylor2208 (8/27/2013)
You can use the free RML utilities by microsoft to perfom this very actionhttp://support.microsoft.com/kb/944837
Not the easiest apps to use but very effective.
Have downloaded, yet to try. Thanks
August 28, 2013 at 9:54 pm
TheSQLGuru (8/27/2013)
tpcc/h
http://hammerora.sourceforge.net/
dvdstore
http://www.sqlstress.com/ - Doesn't support custom script.
http://www.datamanipulation.net/sqlquerystress/ - Very good simple tool, i was looking for some more detail output.
dvdstore - Link doesn't work
http://hammerora.sourceforge.net/ - Looks like this works only for TPC standards, might use this for base lining hardware.
Have you tried this one http://www.sqledit.com, this is not free but gives very good detail. Price is very reasonable.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply