SQLSRVR.EXE high CPU utilization with no real usage

Posted on 2006-04-27
Last Modified: 2012-05-05
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
Question by:phermi
    LVL 15

    Accepted Solution

    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.

    Author Comment

    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
    LVL 69

    Assisted Solution

    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.
    LVL 15

    Expert Comment

    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


    Author Comment

    DonKronos (and all)

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

    LVL 28

    Expert Comment

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

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    I recently came across an interesting Question In EE ( and was puzzled about how to achieve that using SSIS out of the box tasks, which was i…
    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
    Via a live example, show how to setup several different housekeeping processes for a SQL Server.

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now