One of the problems with the SOS_SCHEDULER_YIELD wait type is that its not really a wait type. When this wait type occurs, its because a thread exhausted its 4ms scheduling quantum and voluntarily yielded the CPU, going directly to the bottom of the Runnable Queue for the scheduler, bypassing the Waiter List. A wait has [&]

The post Identifying queries with SOS_SCHEDULER_YIELD waits appeared first on Paul S. Randal.

http://feedproxy.google.com/~r/PaulSRandal/~3/1plG_MkHwPI/