July 27, 2011 at 8:14 am
SKYBVI (7/27/2011)
aNY SOLUTION?
Please start a new thread. This one has been revived 4 times already and I don't think there's much more to add to it at this point.
August 7, 2011 at 8:15 pm
I know this is an old thread but since it seems to be found often on google, I find it important to tell anybody reading this that our collective understanding of cxpackets was upgraded over the years. And by quickly skimming this thread I see some info that could use adjusting.
Paul White has spent a genormous amount of time writing this amazing article debunking that myth once and for all.
Have a nice read : http://www.simple-talk.com/sql/learn-sql-server/understanding-and-using-parallelism-in-sql-server/
December 3, 2012 at 10:00 am
Ninja's_RGR'us (8/7/2011)
I know this is an old thread but since it seems to be found often on google, I find it important to tell anybody reading this that our collective understanding of cxpackets was upgraded over the years. And by quickly skimming this thread I see some info that could use adjusting.Paul White has spent a genormous amount of time writing this amazing article debunking that myth once and for all.
Have a nice read : http://www.simple-talk.com/sql/learn-sql-server/understanding-and-using-parallelism-in-sql-server/
Google search brought me here, LOL. That link isn't working for me. Is it correct?
December 3, 2012 at 10:54 am
December 4, 2012 at 2:55 am
Whilst reducing the number of Processors used will reduce parallelism waits it may not be the best way to 'fix' the query ie. there are probably other underlying issues
A good link on the 'barking dog analogy'
December 4, 2012 at 3:02 am
scogeb (12/3/2012)
Ninja's_RGR'us (8/7/2011)
I know this is an old thread but since it seems to be found often on google, I find it important to tell anybody reading this that our collective understanding of cxpackets was upgraded over the years. And by quickly skimming this thread I see some info that could use adjusting.Paul White has spent a genormous amount of time writing this amazing article debunking that myth once and for all.
Have a nice read : http://www.simple-talk.com/sql/learn-sql-server/understanding-and-using-parallelism-in-sql-server/
Google search brought me here, LOL. That link isn't working for me. Is it correct?
Yes. (Working on part 2 now).
April 19, 2013 at 1:21 am
Good Day,
our environment runs on SQL Server 2008R2 64 bit Ent with 32 CPUs and 200 gig of memory . When I run diagnostics queries to see which processor is busy , there are only 4 processors at a time with readings lower than 10 at a time the others have readings of 0 . We did add the required indexes and tuned the code , but we still get CXPacket SOS_SCHEDULEr_Yield waits . Any ideas ?
April 19, 2013 at 1:29 am
Please post new questions in a new thread. Thanks
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 8 posts - 31 through 37 (of 37 total)
You must be logged in to reply to this topic. Login to reply