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. [wpc_button]
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.