Home Forums SQL Server 2008 SQL Server 2008 Administration Set the MAXDOP setting to 8? RE: Set the MAXDOP setting to 8?
hs24
Default port
Points: 1440
More actions
November 13, 2012 at 7:02 am
#1558471
Best Practice for a Production Environment suggests a value of 1. Just remember that if you change the Max DOP to 8 for maintenance then the plan cache shall be flushed, so be careful if you decide to do this.