April 19, 2013 at 1:50 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_SCHEDULE_Yield waits . Any ideas ?
April 19, 2013 at 2:10 am
Firstly, are those waits a problem? Do you have excessively high CPU usage that is hindering performance.
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
April 19, 2013 at 2:53 am
Good Day,
yes we do have excessive cpu usage .
April 19, 2013 at 2:56 am
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 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply