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: ,,
7. May 2009 03:59 by Danny Gershman | Comments (0) | Permalink

Add comment


(Will show your Gravatar icon)  

  Country flag


Enter Numbers In Image Above: biuquote
  • Comment
  • Preview
Loading



About dannyg

dannyg has been writing software for the last 12+ years and worked with various languages and programs.  He specializes business process automation, versatile solutions and R&D.