Check SQL stress test for Query or Procedure in SQL Server

Download the Stress tool: SQLQueryStress

https://github.com/ErikEJ/SqlQueryStress/releases

Install the SQL Query Stress tool

Click on the Database button to make a connection with the Database. Enter the connection detail of database and test the connection.

Run the Stress test for SQL Query by choosing Number of Iterations and Number of Threads running parallel as shown below and press the GO button to start the Stress test for SQL query or Procedure etc.

It will show you the detail of SQL query taking actual time and you can check with different hints to optimize the SQL Query which will give you the better results.