Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Stress Test Tool - SQL Server 2008R2 - Possibly freeware ? Expand / Collapse
Author
Message
Posted Monday, August 26, 2013 2:55 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, December 16, 2014 9:01 AM
Points: 1,299, Visits: 3,003

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?
Post #1488502
Posted Tuesday, August 27, 2013 6:50 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, November 28, 2014 8:09 AM
Points: 316, Visits: 592
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
Post #1488729
Posted Tuesday, August 27, 2013 7:43 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 7:31 AM
Points: 4,472, Visits: 6,402
http://www.datamanipulation.net/sqlquerystress/ --Adam Machanic's, quite solid and well used
http://www.sqlstress.com/

tpcc/h
http://hammerora.sourceforge.net/

dvdstore
http://www.sqlservercentral.com/blogs/technobabble-by-klee-from-kleegeek/2013/07/29/benchmark-your-sql-server-instance-with-dvdstore/


Best,

Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru at GMail
Post #1488775
Posted Wednesday, August 28, 2013 9:47 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, December 16, 2014 9:01 AM
Points: 1,299, Visits: 3,003
RTaylor2208 (8/27/2013)
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.


Have downloaded, yet to try. Thanks
Post #1489507
Posted Wednesday, August 28, 2013 9:54 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, December 16, 2014 9:01 AM
Points: 1,299, Visits: 3,003
TheSQLGuru (8/27/2013)
http://www.datamanipulation.net/sqlquerystress/ --Adam Machanic's, quite solid and well used
http://www.sqlstress.com/

tpcc/h
http://hammerora.sourceforge.net/

dvdstore
http://www.sqlservercentral.com/blogs/technobabble-by-klee-from-kleegeek/2013/07/29/benchmark-your-sql-server-instance-with-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.
Post #1489510
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse