Degree of parallelism in SQL Server

  • Have a read through chapter 3: http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/

    Unfortunately there isn't an answer that always works everywhere. I like to leave maxdop at 0, raise cost threshold (I'll test queries and see the aprox cost where parallelism brings a benefit) then handle exceptions with either query hints, plan guides or resource governor settings.

    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 post 16 (of 15 total)

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