If you've ever used sp_who and/or sp_who2, you'll appreciate the insight this free script Adam Machanic wrote and shared, sp_whoisactive. Way more useful than the out of the box scripts.
There is a great video tutorial and link to the free download here: brentozar, and even a way to save the results over time to a table.
