Post reply

Weird CPU/Disk spikes

  • October 1, 2009 at 10:34 am

    #134128

    I see on Task Manager/CPU that sqlserver.exe goes from 3 to 25 and then back to 3... every second, this pattern is lasting days. Furthermore, I see on performance that the utilization of disk (data files) has the same spiking behavior. There is no much activity on the database and certainly the spikes happen even when nobody is connected to the server. We have Reporting/Analysis/Integration services up, I'm not sure if any of them has anything to do with this behavior. We recently migrated the database from sql 2000 (where we never had this problem) to sql 2005.

    Version: SQL server 2005 Enterprise x64

    OS: windows 2003 Enterprise x64

    Storage: SAN

  • October 1, 2009 at 3:11 pm

    #1060712

    It happens for me, as well. It's the virus scanner and the SQL "heartbeat"... normally, the heartbeat shows up as a mere ripple... with a virus scanner turned on, it takes the virus scanner some work to let the heartbeat work.

    --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)

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

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