Home Forums SQL Server 2005 Administering Why does my query use MAXDOP = 0? RE: Why does my query use MAXDOP = 0?

  • March 11, 2014 at 8:27 am

    #1696006

    ChrisM@Work (3/11/2014)

    curious_sqldba (3/11/2014)

    sqlbuddy123 (3/10/2014)

    MAXDOP =1 means disabling the parallelism. That's why SQL Server doesn't consider parallelizing the query.

    That's why I couldn't see that in the execution plan you posted.

    --

    SQLBuddy

    Exactly, but my plan is using MAXDOP =0 ( 24 cores) in my case. Did you notice this?

    Yes. Does the query have any function calls?

    No function calls.