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


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

<div>
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.
</div>


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.

<div>
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 &nbsp;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.
</div>


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.

<div>
<div class="content wysiwyg-content">
What is the ideal way to stress test stored procedures? thank you.
</div>
</div>


What is the ideal way to stress test stored procedures? thank you.

stress testing stored procedures

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.

.NET Programming

Programming includes both the specifics of the language you’re using, like Visual Basic, .NET, Java and others, but also the best practices in user experience and interfaces and the management of projects, version control and development. Other programming topics are related to web and cloud development and system and hardware programming.

Programming

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.