Top 10 processes running in the SQL SERVER

 select top 10 * from master.dbo.sysprocesses
 where
 status <> ‘background’
 AND cmd NOT IN
 (‘signal handler’,’lock monitor’,’log writer’,’lazy writer’,’checkpoint sleep’,’awaiting command’,’TASK MANAGER’)
 and spid > 50
 and spid <> @@spid
 order by CPU desc