maxdop and index rebuild

  • Research has shown me this is like arguing religion, for a 128 GIG 48 core SQL 2008 R2 Enterprise edition, with maxdop set to 8, would you change this to 0 for index rebuilds. Vendor recommendation for their database is yes, I am seeing time span to complete that this may not be the answer.

  • tcronin 95651 (5/5/2015)


    Research has shown me this is like arguing religion, for a 128 GIG 48 core SQL 2008 R2 Enterprise edition, with maxdop set to 8, would you change this to 0 for index rebuilds. Vendor recommendation for their database is yes, I am seeing time span to complete that this may not be the answer.

    I may be misinterpreting the question but are they suggesting prior to rebuilding an index you change the server wide MAXDOP setting from 8 to 0, or just the maxdop option when rebuilding the index like so:

    ALTER INDEX PK_Employee_EmployeeID

    ON HumanResources.Employee

    REBUILD WITH (ONLINE = ON, MAXDOP = 0)

    MCITP SQL 2005, MCSA SQL 2012

Viewing 2 posts - 1 through 1 (of 1 total)

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