TABLE 2 Comparison of Features of sp_who, sp_who1, and sp_who2
Feature	sp_who	sp_who1	sp_who2
List all processes by default	Without sort	With sort	Without sort
Display active processes (including background noise)	√		√
Display active processes (background noise removed)		√
Filter by single SPID	√	√	√
Filter by a pool of up to 40 SPIDS		√
Filter by user login name	√	√
Filter by running command		√
Filter by database name		√
Filter by host name		√
Filter by last batch time		√
Filter by program name		√
Filter by open transaction		√
Filter out non-waiting processes		√
Multiple filter panning		√
Detect blocks and head of blocking chain		√
Dynamic column width adjustment		√	√
Parameter validity checking		√
Summary header in any session		√
Duplicate spid column for handy scrolling	Left only	Left, middle, right	Left, right
Number of columns retrieved from sysprocesses table	8	16	11
Potential performance hit on sysprocesses table	No action taken	Minimized	Reduced