stress testing stored procedures

What is the ideal way to stress test stored procedures? thank you.
Who is Participating?
Vitor MontalvãoMSSQL Senior EngineerCommented:
How was you doing regular stress tests until now?
Shouldn't differ just because is a stored procedure.
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Give us some more details as to what you're trying to accomplish.
Ten words doesn't exactly make for an actionable question.
JyozealAuthor Commented:
ok,i wrote a stored procedure which works fine in development environment. i would like to know how this stored procedure performs in production where around 500 concurrent users run this SP. Looking for some pointers.
JyozealAuthor Commented:
we do have a separate testing team that does that but i am not sure how. But before it can go there i would like to see  how many concurrent users my code can handle . Should i use threads in C# and create two connections to DB with calls to same SP and then join the threads? I was going thru some articles and this is what i could come up with.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.