Wait Types – SOS_SCHEDULER_YIELD (44m)

SOS_SCHEDULER_YIELD means the SQL Operating System (SOS) is waiting for a CPU scheduler to yield more time, but this wait is a little trickier than that. You have to look at not just the wait time, but the average wait time, because some SOS_SCHEDULER_YIELD waits can just mean a mostly-idle server running single-threaded queries.

To access this incredible, amazing content, you gotta get Fundamentals of Server Tuning with Wait Stats or Recorded Class Season Pass, or log in if you already shelled out the cash.