Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

We have a SQL Server which suddenly started running at 98%-100% CPU. No idea why. When we turn on SQL Server Profiler, it drops to the 70% range.

Any ideas?

share|improve this question

2 Answers 2

up vote 4 down vote accepted

I suspect you're seeing lower CPU utilization because the SQL Server Profiler is introducing latency. You should find that your problematic queries run even slower when the Profiler is running.

CPU usage notwithstanding the Profile is going to show you what's really going on.

share|improve this answer

Long shot - if the server is a virtual machine, or has power-saving CPUs, perhaps the 98-100% is not the true full CPU capacity. By giving extra demand, perhaps more CPU capacity kicks in?

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.