SQL SERVER – What is Fill Factor and What is the Best Value for Fill Factor

Posted by pinaldave on SQL Authority See other posts from SQL Authority or by pinaldave
Published on Mon, 31 Jan 2011 01:30:28 +0000 Indexed on 2011/01/31 7:29 UTC
Read the original article Hit count: 372

Working in performance tuning area, one has to know about Index and Index Maintenance. For any Index the most important property is Fill Factor.

Fill factor is the value that determines the percentage of space on each leaf-level page to be filled with data. In an SQL Server, the smallest unit is a page, which is made of  Page with size 8K. Every page can store one or more rows based on the size of the row. The default value of the Fill Factor is 100, which is same as value 0. The default Fill Factor (100 or 0) will allow the SQL Server to fill the leaf-level pages of an index with the maximum numbers of the rows it can fit. There will be no or very little empty space left in the page, when the fill factor is 100.

I have written following two article about Fill Factor.

What is Fill factor? – Index, Fill Factor and Performance – Part 1

What is the best value for the Fill Factor? – Index, Fill Factor and Performance – Part 2

I strongly encourage read them and provide your feedback.

Reference: Pinal Dave (http://blog.SQLAuthority.com)

Filed under: Pinal Dave, PostADay, SQL, SQL Authority, SQL Index, SQL Performance, SQL Query, SQL Server, SQL Tips and Tricks, T SQL, Technology

© SQL Authority or respective owner

Related posts about Pinal Dave

Related posts about PostADay