SQL Database -- Fill Factor -- 70% or 80%?
Please see my former question here: http://social.msdn.microsoft.com/Forums/en-US/sharepointadmin/thread/9303f7d4-bfc8-4cb8-a42e-6035ed5eb2ab It references the Microsoft White Paper Database maintenance for Office SharePoint Server 2007. In that paper, on page 11, Microsoft recommends setting SharePoint database Fill Factor to 70%. But if you go into a SharePoint 2007 with SP2 SQL database, go to the actual SharePoint Database Statistics Timer Job, locate the corresponding Stored Procedure called proc_DefragmentIndices, you will find a line that looks like this: REBUILD WITH FILLFACTOR = 80 This means that whenever this SP determines an Index should be Rebuilt, it sets the Fill Factor to 80%, rather than the recommeded 70%. Why does Microsoft recommend 70% Fill Factor, but actually use 80% in the built-in Stored Procedure?
May 25th, 2011 3:51pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics