Ditto what Jack said.
I always install sp_whoisactive and could not live without it (I run version 11.something). The most notable advantage over sp_who or sp_who2 is that you can see the active query that's running instead of the ambiguous "SELECT".
It is worth noting that they are similar but different
animals. sp_whoisactive tells you about stuff running right now (which is why it's not named, sp_whoisSuspendedOrRunnableOrSleeping). My personal preference is to run them both like so:
P.S. sp_askbrent by Brent Ozar will be out soon. It's a fabulous troubleshooting tool. He's still developing it but I had a chance to play around with what he's done so far. Keep an eye out for that!
Edit: included a better pic
-- Alan Burstein
Best practices for getting help on SQLServerCentral
Need to split a string? Try DelimitedSplit8K
Need a pattern-based splitter? Try PatternSplitCM
Need to remove or replace those unwanted characters? Try PatExclude8K
. "I can't stress enough the importance of switching from a 'sequential files' mindset to 'set-based' thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code. " -- Itzek Ben-Gan 2001