Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2003
    Location
    India
    Posts
    523

    Unhappy Unanswered: CPU usage for SQLserver.exe increased!

    hi,
    I have sql server 2k with sp3 on win2k advanced server.
    the sqlserver.exe is consuming 95 to 100% of cpu and the cpu remains at 100% percent most of the times.
    I have checked with the profiler but could not find anything fishy.
    any help would be highly appreciated.
    Regards,
    Harshal.

  2. #2
    Join Date
    May 2002
    Posts
    299

    Re: CPU usage for SQLserver.exe increased!

    Is there anything running at all? Perhaps a block/lock? I would suggest contacting PSS if this problem persists.
    --
    -oj
    http://www.rac4sql.net

  3. #3
    Join Date
    Jan 2003
    Location
    India
    Posts
    523
    what is pps?

  4. #4
    Join Date
    Jul 2003
    Location
    NJ
    Posts
    1

    Re: CPU usage for SQLserver.exe increased!

    Originally posted by harshal_in
    hi,
    I have sql server 2k with sp3 on win2k advanced server.
    the sqlserver.exe is consuming 95 to 100% of cpu and the cpu remains at 100% percent most of the times.
    I have checked with the profiler but could not find anything fishy.
    any help would be highly appreciated.
    Regards,
    Harshal.

    I am currently running windows XP and having the same problem. The only way to fix it is to shut the program down through program manager and it does not affect my operating system. Have you found anything further on this issue>
    ?

  5. #5
    Join Date
    Jul 2003
    Location
    Madrid, Spain
    Posts
    2

    Re: CPU usage for SQLserver.exe increased!

    I could be wrong, but this sounds like the SQl Slammer worm. Microsoft have published details how to deal with it:
    http://www.microsoft.com/security/slammer.asp



    --Original Message--
    I am currently running windows XP and having the same problem. The only way to fix it is to shut the program down through program manager and it does not affect my operating system. Have you found anything further on this issue

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •