SQLSRVR.EXE high CPU utilization with no real usage

SQL 2000 as part of SBS 2000 with SP1, which brings SQL 2000 to SP4.

A web application in test mode, only one user. It's being well so far until recently ... now the CPU is taken by SQLSRVR.EXE.

By the way, no  KB908531 present.

Any ideas, suggestions will be highly appreciatted
Who is Participating?
Try updating the statistics on the tables.  Have you recently performed a lot of inserts, deletes, etc.  ???

Backup the database.  What is your recovery model?  Are you using replication and if you are is it really replicating?

Just a couple of ideas.
phermiAuthor Commented:
DonKronos ...

Thanks for your reply ... the DB in question is actually a BACKUP db that gets updated on a daily basis via replication from our production server. We use it in this "backup" server to conduct tests before depoly new versions to production.Performance it is being good and the db is small.

I am not an expert on SQl, could you please direct me to the statistics update?

Thanks again
Make sure the machine is not suffering from a lack of physical resources, like disk space for swap, or that you have a failed piece of hardware, like a disk drive.
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Here is a link to the stored procedure.  You can run it from the Query Analyzer.


in general you just enter

USE yourdatabase
EXEC sp_updatestats

phermiAuthor Commented:
DonKronos (and all)

Thanks. I forgot to mention that the behaivor is quite new, last couple of days .... no automatic updates, no hardware changes ....

after you upgrade or install the service pack you have to update statistics.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.