CPU Usuage High

  • Hi,

    Our Server CPU is Going 100% usuage all of sudden from last 2 days. Our Current DB size is 70GB. It also contain 5-6 Very Huge Table. Configuraation is as below:

    CPU: 4

    Memory: 8GB

    Service Pack : SQL2000/ SP4

    PAE/3GB Enabled in boot.ini.

    Pls. suggests. What could be the Ideal cause.

    Thanks 

  • Well to be honest I'd lay my hands on an eval of sql diagnostic manager and point it at my server. I think by the time you've gone through all the manual stuff and suggestions you might as well use a proper tool for the job.

    I'd actually make sure it's sql using all the cpu mind - use perfmon or task manager. Prime culprits for high cpu include almost any third party backup agent/tool, any achiving process, rar, winzip etc. any antivirus. Look also for executing msi's, most tools that apply updates or do inventorys will often be a problem. Altiris when executing an inventory can bring a server to its kness and I've seen it misconfigured and suddenly apply hot fixes in the middle of the day.

    Disable all non-essential services , altiris, auto updates, anti virus, 3rd party monitoring tools, backup agents. Kill any process you don't recognise ( use google or similar to identify processes if you're not sure )

    use sp_who2 active  to monitor your executing threads to find the guilty, then track the executing sql with profiler.

    Check disk subsystem for fragmentation, high usage, long i/o completion times

    Essentially eliminate all the non-sql! btw I'd do a quick check on active processes on the sql server first looking for that query from hell!!

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • I hope this will be helpfull.

     

    http://www.sqlmag.com/articles/index.cfm?articleid=93150&

    thanks.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply