Check SQL Server Stress test for Query or procedure

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.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.