THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Adam Machanic

Adam Machanic, Boston-based SQL Server developer, shares his experiences with programming, monitoring, and performance tuning SQL Server. And the occasional battle with the query optimizer.

Announcing SQLQueryStress: A simple query load tool

On October 20, 2004 -- two years ago -- I announced that I was considering writing my own query load testing tool.

Clearly, my follow through on this promise has been incredibly delayed.  But all is not lost, and I'm happy to report that I am true to my word.  As of today, beta-1 of my new SQLQueryStress tool is available for download.

SQLQueryStress is a free tool that provides a simple means of load testing individual queries.  It provides some support for query parameterization and options for collection of I/O and CPU metrics.  It is not intended to replace tools such as Visual Studio Team System's load tests, but rather to be a simple and easy-to-use tool in the DBA or database developer's kit. I think it lives up to that goal, and initial feedback I've gotten from a few people I've shown it to has been positive.  I've been working on this project on and off for around the last eight months, so I'm quite excited to finally release it to the public!

Please check it out and provide me with any feedback you have: What works?  What doesn't work?  What other features would you like to see?  I'm planning to do quite a bit more with this tool, so I'm definitely interested in what users think would be useful.  And of course, please let me know if you find any bugs (but given the rigor with which I've tested this project, there couldn't possibly be any!)

Thanks, and enjoy!
Published Saturday, October 21, 2006 1:29 AM by Adam Machanic

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS



sfibich said:

This is a great tool.

March 11, 2010 9:47 AM

mostafa said:

Good tool i work on it many many time but in SQL Server 2014 it give me not real result the Query on Mangment Studio take 0 Second but on tool take 8 SEC i tried it more time but not Success with me please check it on SQL Server 2014 and let me know your reply


October 22, 2014 6:08 AM

Adam Machanic said:


I haven't had any issues with it on SQL Server 2014. But please note that I personally no longer use this tool except for demos in my presentations. I recommend that users switch to something a bit more powerful, e.g. a load test built it Visual Studio.


October 22, 2014 1:27 PM

Matt said:

Your domain has expired

January 4, 2016 6:07 AM

Adam Machanic said:

January 4, 2016 10:35 AM

Jeff said:

Where can I find an executable for this project?

March 29, 2016 11:55 AM

Daniel said:

Hi Adam,

Thanks for providing the SQLQueryStress tool. But I was trying to download it and it took me to a website where I was not able to download it. Any link where I can download it?



March 31, 2016 11:25 AM

Daniel said:

Thanks Adam again. I downloaded it from this link:



March 31, 2016 11:27 AM

David said:

Where can I download it?

March 31, 2016 1:13 PM

Erik said:

Ok here is an issue I do not know why it is happening.  

When I try and run multiple iterations of a stored procedure that calls stored procedures that currently select random rows from various tables.  It works fine with 1 iteration but if I do any more I receive the following.

"The connection was not closed. The connection's current state is open."

Any ideas?

April 6, 2016 4:07 PM

Jedi said:


Could you recommend any other commercial tool for stress testing a SQL Server (2012, 2016)? SQL Server is on a VM in the cloud. Assuming bandwidth is not an issue, which tool/s can one use to simulate a real-life situation of thousands of transactions per minute, for example?



February 6, 2017 1:59 PM

Adam Machanic said:

February 6, 2017 3:48 PM

Syed said:

I am not able to download this tool since the link isn't valid anymore. Can someone tell me how to get this tool?

May 23, 2017 3:22 PM

Leave a Comment


About Adam Machanic

Adam Machanic is a Boston-based SQL Server developer, writer, and speaker. He focuses on large-scale data warehouse performance and development, and is author of the award-winning SQL Server monitoring stored procedure, sp_WhoIsActive. Adam has written for numerous web sites and magazines, including SQLblog, Simple Talk, Search SQL Server, SQL Server Professional, CoDe, and VSJ. He has also contributed to several books on SQL Server, including "SQL Server 2008 Internals" (Microsoft Press, 2009) and "Expert SQL Server 2005 Development" (Apress, 2007). Adam regularly speaks at conferences and training events on a variety of SQL Server topics. He is a Microsoft Most Valuable Professional (MVP) for SQL Server, a Microsoft Certified IT Professional (MCITP), and an alumnus of the INETA North American Speakers Bureau.

This Blog


Privacy Statement