CPU usage high on one of 8 cpus

• snomadj

  SSCarpal Tunnel

  Points: 4468

  More actions

  November 2, 2012 at 10:03 am

  #270443

  I've been using perfmon to gather the usual stats on a problem server. Problem as in the user is demonstrating unacceptably slow performance. I'm trying to isolate if this is SQL, the app, or something else & what would therefore, help to resolve.

  Amongst other things I've noticed %processor time overall total is 13%. But for 1 CPU of the 8, I'm seeing consistent & prolonged spikes of 80-90%.

  How can I isolate what is running on which CPU, how can I troubleshoot or rule out if this 1 CPU is related to the issue?

  Sometimes a keyword or a pointer is enough for me to get googling in the right direction so I do appreciate any help in this.

• matt.newman

  Hall of Fame

  Points: 3910

  More actions

  November 4, 2012 at 4:40 pm

  #1555860

  Cores or physical by defining "CPU" as you use it?

  Is this a dedicated SQL box or are other applications running?

  Do you have any settings for max degree of parallelism on either the server or explicitly defined in any of the SQL object code being executed?

  Do you have any SQL agent jobs that kick off with execution time stamps patterns that match your CPU spike patterns?