SQL Server Going Nuts!

[zatch]

On Sunday evening I restarted our SQL machine (which is running on MS SBS 2000 along with Exchange.) Until the last hour or so (Wednesday, noon) CPU usage stays between 15 and 30 percent normally. Now, all of the sudden, the processor is bouncing all over the place - from 5 to 100 and everywhere in between. This happens about every three or four days. All I have to do to "fix" it is stop and restart the SQL Server service and we're back to normal CPU usage.

How can I figure out what is causing this within SQL Server? I have looked through the "Current Activity" dozens of times, but I cannot figure out what process is causing the problems.

Any help would be greatly appreciated.

Zatch

 

[Catadmin]

Some silly questions for you.

Have you verified you don't have a virus, any adware or any services that are self starting that affect CPU usages?

Are there any other uses this Server is put to? I.E., Exchange Server, Print Server, File Server, other DBs or accounting programs?

And have you run a Windows Performance Monitor check and a SQL Server Profiler Trace yet?



Catadmin - MCDBA, MCSA
"Just because I'm paranoid doesn't mean the universe *isn't* out to get me!"