High CPU - trying to find the process resonsible

• Keith Thomas

  Old Hand

  Points: 351

  More actions

  July 1, 2009 at 9:10 am

  #135854

  My server has been running at about 70% cpu for most of the last few days. sqlservr.exe is the culprit. I am having a hard time finding the sql process taking up all this cpu. If I look at Activity Monitor I have 87 total items. 3 are suspended, 3 are runnable 10 are Background system processes. How can I find which process is using up all my cpu. I have started playing with Profiler. Help please.

• ps.

  One Orange Chip

  Points: 29422

  More actions

  July 1, 2009 at 9:16 am

  #1018494

  These articles should help you out in finding the culprits:

  http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

  http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

  ---

  
  Pradeep Singh

• John Rowan

  SSC Guru

  Points: 56440

  More actions

  July 1, 2009 at 9:22 am

  #1018500

  Yep, great articles. Once you've generated trace data, it's just a matter of loading the trace data into a table where you can group/sum/search for the processes responsible for the most CPU.

  John Rowan

  ======================================================
  ======================================================
  Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

• Keith Thomas

  Old Hand

  Points: 351

  More actions

  July 1, 2009 at 10:17 am

  #1018554

  Thanks I will take a look.