Question: Max degree of parallelization options seem to be ignored

  • Max DOP = maximum number of concurrently *executing* threads for a single query. Not the maximum number of threads.
    eg, for a query under maxdop 4, there will be a minimum of 5 threads, the 4 executing threads and a controller that's just waiting for them all to be done. There will likely be more threads that are not running.

    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 1 (of 2 total)

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