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 Continue reading MS SQL tool – Who is Active?