Concurrency Testing Stored Procedures

  • 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

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

  • Thanks for the suggestion I will check it out

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply