Performance issue - CPU at 100%

• Raymond van Laake

  SSCarpal Tunnel

  Points: 4212

  More actions

  April 7, 2010 at 11:37 am

  #231477

  Hi there,

  On my SQL2008 server, every other few minutes (with CPU varying between 0%-70% which looks good at the naked eye), the CPU goes to 100% for a minute or so. See:

  

  How can I find out which process is doing this? On the server (MS Server 2008) nothing else than SQL runs. Because it happens at more or less regular intervals I don't think it's because a client does something because then the intervals would be more random. The SQL server does not come to a halt, but I am getting some performance complaints.

  Thanks,

  Raymond

• RBarryYoung

  SSC Guru

  Points: 143329

  More actions

  April 7, 2010 at 12:18 pm

  #1147660

  Go to the "Processes" tab and then sort-descending on the CPU column.

  [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
  Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]