If you’re still using sp_who, sp_who2, and Activity Monitor, listen up: there’s a great free replacement, and it’s now open source, too!
sp_WhoIsActive is a much more powerful way to analyze what’s happening right now on your server. Here’s what you need to know:
- sp_WhoIsActive’s home on Github – releases page – issues
- It’s licensed with the GPLv3, meaning it’s free as in speech
- Excellent documentation on the different parameters
- High fives all around to Adam Machanic (Blog – @AdamMachanic) for his legendary work in building it, and his generosity in open sourcing it
With this, we’ll be deprecating sp_BlitzWho. The only reason we initially wrote it was that we needed something purely open source that we could distribute without any copyright concerns. Now, with Adam licensing sp_WhoIsActive under the GPL license, there’s absolutely no reason that any of you shouldn’t be using sp_WhoIsActive as part of your database troubleshooting routine. You should high-five Adam the first chance you get. Or buy him liquor. Or both.