Home Forums SQL Server 7,2000 General What would cause processor (sqlservr.exe) to peak 99% RE: What would cause processor (sqlservr.exe) to peak 99%

  • How long does the peak last? Not uncommon on any box to hit max cpu for a second or two at a time, it's sustained max that hurts. To track it down, it depends on the culprit. If it's a query or job, running a server side trace would help you identify it. If it's something else on the box - IIS for example, harder to find.