THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - 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

Comments

 

sfibich said:

This is a great tool.

March 11, 2010 9:47 AM

Leave a Comment

(required) 
(required) 
Submit

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

Syndication

Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement