“Fillfactor” is a setting for indexes in SQL Server. When we need to Recreate or rebuild an index, you can tell SQL Server what percentage of each 8K data page used in the “leaf” level of the index it should fill up. By default, SQL Server uses a 100% fillfactor. This mean maximum number of rows need to be fit within a page. If the page is completely filled and new data is inserted in the table which belongs to completely filled page, the “page split” event happens to accommodate new data. This page split process is expensive in terms of the resources.
References:
http://www.brentozar.com/archive/2013/04/five-things-about-fillfactor/
No comments:
Post a Comment