select hostname,program_name,cmd,hostprocess,nt_username,net_address
,login_time,last_batch,db_name(dbid),lastwaittype,spid,kpid
from sysprocesses
order by lastwaittype
select hostname,program_name,cmd,hostprocess,nt_username,net_address
,login_time,last_batch,db_name(dbid),lastwaittype,spid,kpid
from sysprocesses
order by lastwaittype