Finding CPU Utilization on SQL Server

Run this query to see if there is an increasing amount on a particular SPID

select spid, cpu, physical_io from sysprocesses order by cpu desc

Technorati Tags: ,,

Leave a Reply