Post reply

Concurrency Testing Stored Procedures

  • November 5, 2012 at 3:24 pm

    #284159

    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

  • November 5, 2012 at 3:58 pm

    #1556231

    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.

  • November 6, 2012 at 7:03 am

    #1556446

    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