Adam Machanic, Boston-based independent database consultant, writer, and speaker, shares his experiences with programming, performance tuning, and optimizing SQL Server 2000, 2005, and 2008, in conjunction with related technologies such as .NET.
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!
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
About Adam Machanic
Adam Machanic is a Boston-based independent database consultant, writer, and speaker. He has been involved in dozens of SQL Server implementations for both high-availability OLTP and large-scale data warehouse applications, and has optimized data access layer performance for several data-intensive applications. 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 "Expert SQL Server 2005 Development" (Apress, 2007) and "Inside SQL Server 2005: Query Tuning and Optimization" (Microsoft Press, 2007). Adam regularly speaks at user groups, community events, and conferences on a variety of SQL Server and .NET-related topics. He is a Microsoft Most Valuable Professional (MVP) for SQL Server, a Microsoft Certified IT Professional (MCITP), and a member of the INETA North American Speakers Bureau.