What is SP_WHO and SP_WHO2?
Everyone who works on SQL Server may have used the system stored procedure sp_who. But very few knows about sp_who2. Because sp_who2 is not documented in msdn. Both SP_WHO and SP_WHO2 are Microsoft system stored procedures used to find the current and active session details. SP_WHO2 is similar to SP_WHO with some more details.
SP_WHO:
SP_WHO returns the below details:
Session ID
Execution context ID
Login name
Host Name
Session ID of the blocking process
Database Name
SQL Statement
Sample SP_WHO Execution:
SP_WHO2:
SP_WHO2 will also return all the details like SP_WHO, in addition, it will return the below specified additional details. SP_WHO2 will be very helpful when you want to see the current blocking sessions along with the CPU utilization and the disc I/O usage.
CPUTime
DiskIO
LastBatch
ProgramName
Sample SP_WHO2 Execution:
