Cek User Proses - SQL Server

select *
from master..sysprocesses
order by cpu desc

--Cek prosesan/cpu tinggi--
select spid, waitresource, cpu, physical_io, memusage, status, hostname, program_name,nt_username, loginame
from master..sysprocesses
order by cpu desc

--Cek user yang diblok user lain--
select spid, blocked, waitresource, program_name, nt_username, loginame
from master..sysprocesses
where spid <> blocked
and blocked > 0

--cek user--
--dbcc inputbuffer(428)
--sp_who2 428