While working with a large client we ran into issue with the documentation for SharePoint Maintenance Plans in this SharePoint 2010 Best Practices Document. Andy Lin, a colleague and expert SQL DBA found the problem. It appears when you set the fill factor to from inside the GUI in SQL 2012 to rebuild the index and change per page percentage settings in the maintenance plan to 80 percent it does the opposite and sets it to 20.
Microsoft provided a wrong setting in the SharePoint best practice document.
Yes the Fill Factor changed to 80 percent in the 2010 document. Free Space Per Page means opposite to Fill, should be 20 percent if you want Fill Factor to be 80 percent. See View T-SQL for the plan shows FILLFACTOR=80.
It will be worse if we set a reverse value to 20 percent as shown below.
by Tony Di Leonardo via Everyone's Blog Posts - SharePoint Community
No comments:
Post a Comment