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

Concurrency Testing Stored Procedures Expand / Collapse
Author
Message
Posted Monday, November 5, 2012 3:24 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, November 12, 2014 9:49 AM
Points: 23, Visits: 1,575
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


Post #1381281
Posted Monday, November 5, 2012 3:58 PM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Tuesday, November 19, 2013 8:15 AM
Points: 652, Visits: 1,428
Cory Blythe (11/5/2012)
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



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.
Post #1381296
Posted Tuesday, November 6, 2012 7:03 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, November 12, 2014 9:49 AM
Points: 23, Visits: 1,575
Thanks for the suggestion I will check it out
Post #1381554
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse