IO_COMPLETION and SOS_SCHEDULER_YIELD waits occur together?
2013-04-26 13:53:27
This is just a generic question. Under what scenarios does IO_COMPLETION and SOS_SCHEDULER_YIELD waits occur together?
2013-04-27 09:53:34
Generic answer 🙂
Any query where one or more threads use their whole quantum before rescheduling themselves will generate SOS_SCHEDULER_YIELD. IO_COMPLETION is most commonly associated with a sort that runs out of memory and has to spill to disk.