Post reply

MS-SQL-7 server piking t0 100% CPU

  • March 20, 2006 at 5:08 am

    #111485

    Hi everybody, we have a MS-SQL-7 server piking (plateaus) to 100% CPU.

    It is caused by mssqlserver.exe. How can we find out, what database access is causing this, since I have about 20 DBs running on them ?

    We have Win2000 server, SP4.

    Thanks !

    Uwe

  • March 21, 2006 at 6:21 am

    #627842

    If examining master..sysprocesses (sp_who, sp_who2) doesn't give you enough clues, then download and run pssdiag.exe and read80trace (rml.exe) from microsoft.com. They collect and analyze a ton of info for you.

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

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