Post reply

Very High CPU Usage

  • October 16, 2009 at 8:26 am

    #227147

    Quick question, maybe you folks can point me in the right direction. I have a SQL instance that is using 80-90% of the CPU time. All other counters (and I mean that seriously) are well within acceptable ranges: Disk queue length on all drives is 2-4, response time is 7-10 ms, buffer cache hit ratio is 99.5%, Percent disk use averages 10%, Ad-hoc cache size is about 1 Mb and has about 10% hit ratio. What else do you need to know? Why is the CPU usage so far out of line when all other metrics are in good shape?

  • October 16, 2009 at 10:12 am

    #1067025

    What's your index fragmentation like? Are you doing regular rebuilds/reorgs?

  • October 16, 2009 at 10:23 am

    #1067032

    Index fragmentation is 85% on 7 tables.

    Indexes are rebuilt weekly.

  • October 17, 2009 at 8:11 am

    #1067324

    what about stored procedure/query (re)compilation ?

  • October 17, 2009 at 7:25 pm

    #1067367

    Start out simple... what does TaskMgr say the CPU is being used by?

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • October 18, 2009 at 12:29 pm

    #1067436

    Darrell W (10/16/2009)

    Index fragmentation is 85% on 7 tables.

    Indexes are rebuilt weekly.

    just going back to this that is a high fragmentation percentage.

    7 tables out of how many? What size (in pages) are those tables? Are they heaps?

    ---------------------------------------------------------------------

Viewing 6 posts - 1 through 5 (of 5 total)

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