SQL Server 2008 R2 CPU

• Grace09

  SSCommitted

  Points: 1532

  More actions

  June 12, 2015 at 8:49 am

  #318197

  SQL Server 2008 R2 SP2, the cpu spikes, but I can't find out which process causes it. Thanks in advance.

  

• Shawn Melton

  SSC-Insane

  Points: 24685

  More actions

  June 12, 2015 at 8:53 am

  #1805082

  Open "perfmon /sys" from the run prompt.

  Add the

  /Process (sqlservr.exe)/% privileged and /% processor

  /Processor time for the same objects

  It will at least tell you if it is SQL Server.

  Shawn Melton
  Twitter: @wsmelton
  Blog: wsmelton.github.com
  Github: wsmelton