• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 385
  • Last Modified:

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
0
phermi
Asked:
phermi
2 Solutions
 
DonKronosCommented:
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.
0
 
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
0
 
CallandorCommented:
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.
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

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

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_ua-uz_14kz.asp

in general you just enter

USE yourdatabase
EXEC sp_updatestats

0
 
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 ....

0
 
imran_fastCommented:
after you upgrade or install the service pack you have to update statistics.
0

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now