InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 14:12:57 GMT20http://www.sqlservercentral.com/Forums/Topic1381281-360-1.aspxThanks for the suggestion I will check it outTue, 06 Nov 2012 07:03:24 GMTCory Blythehttp://www.sqlservercentral.com/Forums/Topic1381281-360-1.aspx[quote][b]Cory Blythe (11/5/2012)[/b][hr]I have an request from a client to test a stored procedure that may run up to 500 times concurrently due to user application calls. They want me to test it with 'several hundred' concurrent calls at one time.I have no idea how to do something like this, does anyone have any experience doing this sort of thing?Thanks[/quote]You might want to try the following SQL Server Query Stress tool developed by Adam Mechanic:http://www.datamanipulation.net/sqlquerystress/We've successfully used it to test concurrent executions of a stored procedures for a couple of efforts.Mon, 05 Nov 2012 15:58:26 GMTGeorge M Parkerhttp://www.sqlservercentral.com/Forums/Topic1381281-360-1.aspxI have an request from a client to test a stored procedure that may run up to 500 times concurrently due to user application calls. They want me to test it with 'several hundred' concurrent calls at one time.I have no idea how to do something like this, does anyone have any experience doing this sort of thing?ThanksMon, 05 Nov 2012 15:24:55 GMTCory Blythe