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?
You might want to try the following SQL Server Query Stress tool developed by Adam Mechanic:
We've successfully used it to test concurrent executions of a stored procedures for a couple of efforts.