Performance Issues & Load Stressing Exercises are never faraway ideas from a DBA thoughts.
Let us try out SQLQueryStress.
SQLQueryStress born out of work by Adam Machanic.
Now maintained by Erik Ejlskov Jensen ( ErikEJ ).
The source code for SQLQueryStress is available from ErikEJ’s GitHub site.
Here is the URL :-
Please download the source code from the GitHub site:
Please launch Visual Studio.
The community edition V2017 is the one that I have.
Access the Source Code’s solution file and build the solution.
Once built we will access the bin\Debug for the executable ( SQLQueryStress.exe )
- Please click the Database button to enter Database specification details
- Integrated Authentication
- SQL Server Authentication
- Load Details
- Number of Iterations
- Number of Threads
Please press GO to execute the test.