Post reply

High CPU. Many processes have SOS_SCHEDULER_YIELD

  • August 2, 2011 at 2:14 pm

    #1362618

    GilaMonster (6/6/2010)

    Two-year-old-thread alert.

    Actually 3 years now.

  • September 12, 2011 at 6:35 am

    #1379935

    SOLUTION: UPDATE STATISTICS on key table used within the query. My query returned in < 10 seconds where before I was killing it after 10, 20, 30 minutes (my tables were completely cached in memory) SOS_SCHEDULER_YIELD gone, query executing normal, PAGEIOLATCH waits everywhere... yea !!!

    -CqlBoy

    I know this is 3 year old thread, but could not resist to post as the solution worked liked bingo...!!!.

    Thanks to CqlBoy.

    -Jagga

  • September 12, 2011 at 6:36 am

    #1379937

    JG-324908 (9/12/2011)

    SOLUTION: UPDATE STATISTICS on key table used within the query. My query returned in < 10 seconds where before I was killing it after 10, 20, 30 minutes (my tables were completely cached in memory) SOS_SCHEDULER_YIELD gone, query executing normal, PAGEIOLATCH waits everywhere... yea !!!

    -CqlBoy

    I know this is 3 year old thread, but could not resist to post as the solution worked liked bingo...!!!.

    Thanks to CqlBoy.

    -Jagga

    NP, that's actually useful info to post. 🙂

Viewing 3 posts - 16 through 17 (of 17 total)

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