I am trying to run a SQL query for finding out which process (TID) of SQLServer is causing high CPU.
I ran process explorer and found that some of the TIDs are
So, I tried running the query as shown
Select SPID from sysprocesses where kpid=8792
I am not sure what to select for SPID and sysprocesses. Should I select @@SPID for SPID and for sysprocessess what should I select? I am new to SQL DB administration never had done a query.