Post reply

CXPACKET

  • April 19, 2013 at 1:50 am

    #394630

    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

    #1608107

    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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • April 19, 2013 at 2:53 am

    #1608115

    Good Day,

    yes we do have excessive cpu usage .

  • April 19, 2013 at 2:56 am

    #1608119

    Chapter 3: http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/

    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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply