Here is an awesome extentions of the sp_who and sp_who2 (undocumented) sprocs DBA’s use to see slow running queries etc.

Download link for v11.11
Website for sp_WhoIsActive
Extending sp_WhoIsActive

Views – 2253