May 5, 2015 at 8:20 am
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.
May 13, 2015 at 6:16 am
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