stress testing stored procedures

Give us some more details as to what you're trying to accomplish.
Ten words doesn't exactly make for an actionable question.

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.

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.