Adam Machanic : Testing

CloudSeeder: CLR Stored Procedures For Creating CPU Pressure

Adam Machanic — Tue, 23 Oct 2012 19:49:00 GMT

Sometimes, in the interest of testing various scenarios that your server might encounter, it's useful to be able to quickly simulate some condition or another. I/O, memory, CPU pressure, and so on. This latter one is something I've been playing with a...(read more)

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!

Introducing: TSQLMacro

Adam Machanic — Thu, 13 Jul 2006 01:37:00 GMT

I am pleased to announce the official introduction of the TSQLMacro framework, version 0.5 (prebeta-1). This version is functionally complete based on the initial design spec, features are stable, and I am not currently aware of any bugs.

So what is TSQLMacro? You can get a complete rundown here. But in essence, TSQLMacro is my attempt to bring C/C++-style macro and preprocessor support into TSQL, in order to ease certain development burdens. Please read the TSQLMacro Introduction for a detailed analysis of those issues.

And of course, there's a download page. But I highly recommend reading up before downloading -- I haven't yet included a readme or any other kind of documentation in the download.

As always -- and especially, in this case -- I would appreciate any comments, feedback, suggestions, rants, or other things you'd like to tell me about this project! I've spent a huge amount of time -- way too much time -- working on this, so I'm eager to see what people think! Thanks!

Introducing: TSQLAssert

Adam Machanic — Thu, 13 Jul 2006 01:37:00 GMT

Yes, yet another introduction (although there was almost zero reaction to yesterday's introduction).

Today, I introduce the first thing built on top of TSQLMacro. I proudly present the TSQLAssert debug assertion framework!

For those of you who've worked with assertions before, I think you'll enjoy this quite a bit. It provides similar functionality to assertions in other languages, and I think it will be great for debugging and perhaps as an addition to environments using TSQLUnit.

For those of you who haven't felt the joy that is asserting in your code, check out the following intro in the Wikipedia: http://en.wikipedia.org/wiki/Assertion_%28computing%29

As always, feedback is appreciated! Thank you!