sp_WhoIsActive Is Now Open Source.

Adam Machanic, Japanese Snack Connoisseur

Adam Machanic, Japanese Snack Connoisseur

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:

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.

Previous Post
DBA Training Plan 5: Knowing Who Has Access
Next Post
Podcast: Data Driven Inteview w/Me

21 Comments. Leave new

  • Adam – thank you for one of the best and most-used tools in my arsenal! And thanks to you, Brent, for recognizing the importance of this going open source and using real estate on your website!

    Reply
  • Michael Sosis
    July 29, 2019 9:33 am

    The number One utility in my Utility belt… (no offense to the Brent’s utilities). High five to Adam and drinks on me as soon as opportunity to do that comes up.

    Reply
  • Don Kolenda
    July 29, 2019 9:36 am

    This is great news! Thank you so much, Adam!

    Reply
  • Calvin Jones
    July 29, 2019 10:08 am

    I use both sp_BlitzWho and sp_WhoIsActive. Please keep sp_BlitzWho.
    High five to Brent and Adam.

    Reply
  • Does anyone have an easy method to centrally deploy tools like these to several SQL servers in some sort of automated process?

    Reply
  • Yeah, I had played with that a bit, but I believe the ‘GO’ batches in some of the scripts were stopping the job in the where ever the batch stopped. I made something using dynamic SQL that avoided that, but it was complicated enough that I could never remember how to run it without playing with it for a bit and eventually gave up on it.

    Reply
  • Thank you both very much for your contributions to helping DBA’s as myself

    Reply
  • Big shout out and thank you! I would love to add [context_info] from [dm_exec_sessions]. Perhaps someone will add, I wish i had time to play… Love you guys!

    Reply
  • Thank you both for helping DBAs!

    Reply
  • Many Thanks, you both
    And now it runs On SQL Azure – WOW!!!

    Reply
  • Thanks this is great news. Always the first tool I recommend and much easier than activity monitor – is there any difference between this and sp_BlitzWho? I have only ever tried the former.

    Reply
  • […] sp_WhoIsActive Is Now Open Source In fact, it happened a few months ago. Thanks to Adam Machanic for open-sourcing the code. […]

    Reply
  • Denis Kiriyak
    October 8, 2019 10:45 am

    Is Adam fine and alright? There’s no activity of him on Twitter and dataeducation.com/blog since mid 2018, SQLBits and other conferences, sqlblog.com is down…
    Glad to suddenly see some info about him here in 2019 and his famous utility.

    Reply
    • Yeah, he’s fine. He’s not working that much with SQL Server anymore though. He presented at SQL Saturday Boston a couple of months ago and I had the chance to talk with him – he’s great as usual.

      Reply
      • Denis Kiriyak
        October 8, 2019 1:31 pm

        Thank you for info about him, Brent.
        I think that SQL Server community lost a strong expert of “manhandling parallelism”, SQL CRL programming and more other stuff. I hope he’ll return to SQL Server some day. Who’s gonna talk about hidden gems in SQL Server 2019 now 🙂 ?

        Reply
  • Thanks Adam. sp_whoisactive is a tool everyone should have. Looking forward for more improvements as the tool is now open to the community.

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *

Fill out this field
Fill out this field
Please enter a valid email address.

Menu
{"cart_token":"","hash":"","cart_data":""}