May 19, 2015 at 11:40 pm
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
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
May 20, 2015 at 4:07 am
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 Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 21, 2015 at 5:26 am
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