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|http://www.youtube.com/watch?v=vvziPI5OQyE&hd=1
You can find this wonderful MS SQL server tool by Adam Machanic at http://sqlblog.com/blogs/adam_machanic/archive/2010/10/21/who-is-active-v10-00-dmv-monitoring-made-easy.aspx