Post reply

sql server 2000 on server CPU taking 98%

  • September 20, 2008 at 12:28 am

    #71986

    hi,

    pls anybody give me tips, for sql server 2000 on server CPU taking 98%

    thanks

  • September 20, 2008 at 2:26 am

    #874556

    Hi,

    This is a very generic question. If this issue occurs occassionally check any query/job is causing this.

    If the CPU usage is always spiking, try checking your hardware configuration.

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

  • September 20, 2008 at 2:45 am

    #874561

    Run profiler for a while and look for queries that have very high CPU usage. Take the top 3 or so and see if you can optimise them. That may require rewriting the code, it may require changing indexes, it may require both.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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