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”.
[youtubegallery]
Brent Ozar – How to find slow SQL queries|http://www.youtube.com/watch?v=vvziPI5OQyE&hd=1
[/youtubegallery]

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

Thanks Adam!

Leave a Reply