Who is Active? is a comprehensive DMV-based monitoring script, designed to tell you at a glance what processes are active on your SQL Server and what they're up to. It has a number of optional features so that you can get results quickly, or monitor deeply, depending on your needs when you happen to be using the script. Today I'm happy to present a new version, v7.30, which includes a few bug fixes an a new feature.
Click here to download Who is Active? v7.30
Now that I've covered that (for people who haven't been paying attention to this blog as of late), a bit of commentary. After posting Who is Active? v7.22 on December 31, I expected to receive a huge amount of feedback from the community. Alas, there were a few issues:
- It turns out that December 31 is not a great day for a blog post that you would like to get lots of hits.
- Apparently many readers were confused about where to actually download the script.
- I was told that I need to document the thing better.
Luckily, some users did manage to download it, and I even received some feedback. Great feedback, primarily from a reader named Bill Kan. Thanks for all of your time, Bill! I also discovered a couple of issues on my own, and added a new feature that I thought of while watching Grant Fritchey do an excellent talk at New England Data Camp v1.0.
So now to address those three issues. I'm posting this post on a Wednesday, it's not a holiday, and it will hit midday, so that covers issue #1. For issue #2, see above and see below. I think the download links are painfully obvious at this point. And as for issue #3, well, I'm sorry to say that today is not the day for that one. I've done a fairly good job of documenting the script in the script (download it and take a look), and I think most readers will be able to feel their way around well enough. If you have any questions, post them here and I will be happy to answer. And eventually I will write up a comprehensive document on the thing. But until then, two out of three isn't bad...
Click here to download Who is Active? v7.30
Please give it a try and let me know what you think. I've run out of new feature ideas for the moment and could certainly use some input. If you are using it, please let me know what features you've found to
be helpful and how you're integrating it into your work. I'm hoping to
identify a number of use cases as talking points for the forthcoming
document on the script and actual user feedback will be key.
And, most importantly, enjoy! As I mentioned in December, this script has become a vital part of my toolkit; I have to say that it's made certain aspects of monitoring a lot easier and more interesting for me and I hope it does the same for you.