SOS_SCHEDULER_YIELD

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

  1. Indexing, look for high CPU queries
  2. Upgrade CPU capacity
  3. Ensure that the Windows Power Plan is set to High Performance
  4. 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

See more

Consider using ApexSQL Monitor, a Windows and SQL Server monitoring tool able to track SQL Server wait types, including the individual query wait statistics

⇐ Back to index