Description
Caused by requests requiring heavy amounts of CPU. This wait is different from others as it accumulates on the runnable queue. It will not show in sys.os_waiting_tasks as the only thing the request is waiting on is the CPU itself
Resolved by
DBAs and Developers
Suggested solutions
- Indexing, look for high CPU queries
- Upgrade CPU capacity
- Ensure that the Windows Power Plan is set to High Performance
- For virtual servers ensure the host is not oversubscribed
Additional research
How to handle excessive SOS_SCHEDULER_YIELD wait type values in SQL Server
Optimizing SQL Server CPU Performance
Knee-Jerk Wait Statistics : SOS_SCHEDULER_YIELD