sp_who2 ⇥ Handy, undocumented stored procedure to quickly see current SQL Server connections and/or queries along with CPU time and duration. link