CPU Usage 100% SQLServr.exe

• cintia oliveira

  SSC Enthusiast

  Points: 110

  More actions

  January 12, 2004 at 10:22 am

  #84347

  Hello!!!

  I have a SQL 2000 Standard Edition (SP3) installed on a Win2000 server (SP4 with Patches) and since last thursday, the SQLServr.exe process is hitting more than 97% of CPU Usage.

  SQL memory is configured to dynamically (min. 0 / max 719) and nothing was changed on the server that might be causing this problem.

  I used sp_who2 but there are no obvious problems and I verify about virus but nothing was found either.

  Could you help me to find and solve the problem, please????

  Thanks!!!!

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736255

  More actions

  January 12, 2004 at 1:52 pm

  #489636

  Run profiler and see what is hitting the server.