SQL CPU işlem sorgulama

 SELECT spid ProcessId, blocked as kilitleyenId, waittime/1000 as BeklemeSuresi_sn,
                    hostname,cmd, loginame,nt_username,program_name, *
                    from master.dbo.sysprocesses
                    where spid > 50 --and spid=380 --and loginame='orhan' --and  waittime >0
                    and dbId=(Select database_id from master.sys.databases where name='user database' )
                    --and blocked > 0 --(database i kilitleyenleri bu sekme ile görebiliriz.)
                    order by  master..sysprocesses.spid desc, master..sysprocesses.waittime desc