Rob Kraft's Software Development Blog

Software Development Insights

SP_WhoIsActive is a Superior Alternative to sp_who on SQL Server

Posted by robkraft on August 13, 2012

I recently learned about the sp_WhoIsActive stored procedure written and maintained primarily by Adam Mechanic.  For DBAs like myself who have always wanted something better than sp_who and sp_who2 to diagnose the active connections on your SQL Server, this is a tool for you.  You can download it at and you can learn all about it through Adam’s many blog posts.  I recommend starting with this one:


Find more tool gems like this at


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: