MS SQL tool – Who is Active?

I just recently found Who is Active and it has now become a favorite tool in my Microsoft SQL server tool-belt. Yes, move over sp_who2.

Who is Active displays only those processes or T-SQL queries that are currently active on the server. The display provides which SPID’s is hitting the SQL server,  locking processes, blocking sessions, and pull execution plans. A big benefit “Who is Active” has over sp_who2 is the T-SQL query is formatted properly in a new window.

Brent Ozar produced this little video demonstration of “Who is Active”.
Brent Ozar – How to find slow SQL queries|

You can find this wonderful MS SQL server tool by Adam Machanic at

Thanks Adam!

Leave a Reply