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
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