Post reply

What happens when CPU running at 90% usage more than 24 hours

  • February 29, 2012 at 2:26 pm

    #269320

    Hi,

    We have SQL Server 2008 R2 box. One of the SQL backup job hang and the server taking more than 90 % of CPU usage from last 24 hours.

    What happens when CPU running at 90% usage for more than 24 hours?

    Thanks

  • February 29, 2012 at 2:29 pm

    #1453378

    You may experience degraded performance in some areas. Monitor it for slow response. You may have something that is still running causing the cpu spike. See if you can find that process.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • February 29, 2012 at 2:58 pm

    #1453388

    I don't remember how the CPU load was, but I once had a scenario where the backup all of a sudden needed more than 24 hours to complete. In my scenario, the backup disk where on a disk shelf where the backup batteries was flat. If a disk shelf or a raid controller has flat batteries, write cache may be automatically disabled.


    Ole Kristian Velstadbråten Bangås - Virinco - Facebook - Twitter

    Concatenating Row Values in Transact-SQL[/url]

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

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