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!