The sysprocesses table in SQL Server

Monitoring of Cpu,io, memory in SQL Server DB during performance testing

Resource usage can be viewed through the system process table

Note to have Master permissions

Select top * from sysprocesses ORDER by CPU desc
Select top * from sysprocesses ORDER BY physical_io Desc
Select top * from sysprocesses ORDER BY memusage Desc

status: Process ID status
dormant = resetting the reply;
running = reply is running one or more batches;
background = reply is running a background task;
rollback = Session is processing transaction rollback;
pending = reply is waiting for work to become available;
runnable = The task in the session is in an executable queue that is waiting to get Scheduler to run; /span>
spinloop = The task in the session is waiting for the spin lock to become available;
suspended = Session is waiting for event completion

The specific meaning that the table uses

The sysprocesses table in SQL Server