Post reply

SOS_SCHEDULER_YIELD is high

  • May 19, 2015 at 11:40 pm

    #318242

    Dear All,

    I am facing high CPU utilization issue , cpu utilization is up 100 % contentiously for long time. I gone through sys.dm_os_wait_stats and found value for counter SOS_SCHEDULER_YIELD is too high and most of requests are waiting for SOS_SCHEDULER_YIELD.

    I want to know possible reason for this counter and what can i do to reduce cpu load.

    Thank you All

    -----------------
    Aditya Rathour
    SQL DBA

    Not Everything that is faced can be changed,
    but nothing can be changed until it is faced.

  • May 20, 2015 at 12:15 am

    #1799241

    High cpu-consuming queries. Identify the queries and tune them.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • May 20, 2015 at 4:07 am

    #1799274

    Also, look at your cost threshold for parallelism. If it's at the default value of 5, it needs to be bumped up.

    ----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software

  • May 21, 2015 at 5:26 am

    #1799608

    Thanks Gila Monster and Grant Fritchey

    I analyzed and tune the queries consuming more cpu resources.

    It resolved high CPU utilization(continuously 100%) problem and also improved performance .

    -----------------
    Aditya Rathour
    SQL DBA

    Not Everything that is faced can be changed,
    but nothing can be changed until it is faced.

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

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