Post reply

sqlservr.exe showing high CPU

  • July 21, 2009 at 7:55 am

    #207202

    sqlservr.exe showing high CPU on Task manager. There are many select hitting the database. THis database is for website.

    I checked no blocked session, no open tran. no error on error log...is this database issue?

  • July 21, 2009 at 8:17 am

    #1027636

    there are high CPU time to time, every 5 mins just for few sec though. Activity monitor shows lot of connection for the time CPU is high and it just last for few seconds.

    That means there are lot of connection for few seconds and they are gone. Is this normal?

  • July 21, 2009 at 6:30 pm

    #1028044

    It could be normal for the apps you're running or there might be a scheduled job that runs every 5 minutes or it could be replication or it could be....

    The key is, you don't know. You might want run profiler for SQL:Batch Complete to start with and find out what it is. Make sure you include things like the SQL Text column, CPU, and duration. Might want to include a filter (to start with) that only let's things through for more than a second of CPU time... between that and the batch complete setting, usually makes for very small return that you can run for weeks at a time without overloading the system.

    --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 3 posts - 1 through 2 (of 2 total)

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