Announcing SQLQueryStress: A simple query load tool

Adam Machanic — Sat, 21 Oct 2006 04:29:00 GMT

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!

Adam Machanic : Testing, Performance

Announcing SQLQueryStress: A simple query load tool