IO_COMPLETION and SOS_SCHEDULER_YIELD waits occur together?

arvindravish 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?
SQLkiwi 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.