A quick and simple SysProcess query which will display most of the common parameters of interest. Can be useful for a quick reference. [Not disputing the fact of SP_WHO and SP_WHO2 and SP_WHO3 ... et al]
A simple SysProcess query
USE MASTER -- SELECT SPID,KPID, '[' + CAST(DBID AS VARCHAR(10)) + '] ' + DB_NAME(DBID) DBNAME, PROGRAM_NAME, HOSTNAME, CMD, OPEN_TRAN, LASTWAITTYPE, CPU, PHYSICAL_IO, STATUS, LOGINAME, NT_USERNAME, NT_DOMAIN FROM MASTER..SYSPROCESSES WHERE SPID > 50