CPU Utilization maxes out

  • Hi all,

    I have a problem that I'm having a difficult time trying to solve. Basically, every Sunday night, at roughly the same time each week, the server becomes more or less unreponsive. Other servers cannot communicate via linked server, and when attempting to log on to the machine via RDP, the machine reacts very sluggishly.

    When I finally do manage to connect via RDP, looking at the task manager shows that the SQL Server process is using up all available CPU. I can't even connect to SQL Server using sqlcmd or SSMS, nor can I connect using the DAC.

    This lasts for around two hours, after which the server returns to normal functionality.

    Can anyone help me with finding out what is happening on the server at this time? I've looked over the log files, there is no trace of any problems occurring. The last job which is set to execute finishes at about 9:50 PM.

    Any ideas on where I can look to find what is going on?

  • If it happens consistently, schedule a server-side trace to start just before the problem occurs and run long enough to catch the entire thing, then you can review the trace file and see what was in it.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • Thanks for the suggestion, Gail.

    I've scheduled the server-side trace. Now we see if it finds anything for me ...

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply