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.