What Is SOS_SCHEDULER_YIELD?
Jun 7, 2007
what is SOS_SCHEDULER_YIELD?
and when dose SOS_SCHEDULER_YIELD work?
if having more CPU, will SOS_SCHEDULER_YIELD be influenced by?
thanks for reading
ADVERTISEMENT
SOS_SCHEDULER_YIELD
Aug 29, 2006I have a job running in 2 separate environments. In the first it runs very quickly (~5 seconds), however in the second it runs it takes MUCH longer (~5 minutes). These two machines have identical hardware and similar load. When I look at sys.sysprocesses to see what else is running, the long running machine always has the job step listed as SOS_SCHEDULER_YIELD as its wait_type. I know this is a natural yield for the step, but I don't think it should be yielding for this long, especially if nothing else is running. I have no idea where to look or what to change on this one. Any help would be greatly appreciated.
Thanks.
Query Waits On SOS_SCHEDULER_YIELD For Ever
Jun 21, 2007HI,
I have a query that keeps on waiting with a wait type of SOS_SCHEDULER_YIELD. I have checked for the CPU pressure as well, and there is nothing else running. The query outline is given below.
Select a,b,c,d....
FROM tableA A inner join tableB B on A.a = B.b
inner join tableC on B.c = C.c
where
a.x not in (SELECT x from tableX where y = '???')
I have restored the copy of prod DB on a DEV box and ran the query which runs fine. But the prod box which is more powerful chokes. DEV is a 4CPU/4GB box and PROD is 8CPU/32GB box. All other DB and Server settings are exactly the same. DEV is SQL 2005 Standard ed SP2. Prod is a SQL 2005 Enterprise ed SP2.
Thanks in advance,
Sirish