Today's SQL Server tip

SP_WHO OR SP_WHO2 v7.0
Most SQL administrators are familiar with the system monitoring stored 
procedure sp_who, which delivers session-specific information about 
what is happening on your SQL Server at any given moment. While this 
procedure is extremely useful, it is sometimes cumbersome to read due 
to the left/right scrolling necessary to get to the information from 
ISQL/W.

Another system stored procedure exists that is very similar to sp_who 
called sp_who2. There are no references to sp_who2 in MSDN SQL Server 
Books Online and very little information in other reference materials 
regarding its existence.

These two procedures obtain information from the sysprocesses table, 
format the information, and present a synopsis of ongoing activity on 
the SQL Server to the user. Specifically, both procedures provide 
information on SPID, status, loginname, hostname, blocks, dbname, and 
command. But sp_who2 delivers more information on CPUTime, DiskIO, 
LastBatch, and ProgramName.

Mutual sp_who and sp_who2 output:

SPID Status   Login  HostName BlkBy DBName  
---- -------- ------ -------- ----- ------   
7    sleeping JSMITH WSSELST1       test01  
8    RUNNABLE JSMITH WSSELST1       test01 

Additional sp_who2 output:

Command          CPUTime DiskIO  
---------------- ------- ------  
AWAITING COMMAND 0       0       
SELECT INTO      0       31      
 
LastBatch      ProgramName           SPID 
-------------- --------------------- ---- 
07/18 10:33:55 MS SQL Query Analyzer 7 
07/18 10:41:45 MS SQL Query Analyzer 8

------------------------------------------