SOS_SCHEDULER_YIELD

Aug 29, 2006

I 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.

View 1 Replies


ADVERTISEMENT

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

View 5 Replies View Related

Query Waits On SOS_SCHEDULER_YIELD For Ever

Jun 21, 2007

HI,

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

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved