SQL Server Performance Forum – Threads Archive

Index: fill factor unchecked

Hi ! One of my tables has fillfactor unchecked .
I’ve read that if it’s 0 then index uses the fill factor that was on
the table when it was originaly created. How I find out what fill factor if was? And also might it be specific
factor for that configuration? Or it’s most probably a mistake?

Run sp_configure to see what is your default fill factor.
And average value could be 80.
0 or 100 are good value for tables with insert at end of table.
Take help from BOL.
Luis Martin
Moderator
SQL-Server-Performance.com

I think there were few good posts about fill factor earlier, search on the forum.
As referred by Luis using SP_CONFIGURE is only way to know the status of fill factor. BOL refers:
The default for fill factor is 0; valid values range from 0 through 100. A fill factor value of 0 does not mean that pages are 0 percent full. It is treated similarly to a fill factor value of 100 in that SQL Server creates clustered indexes with full data pages and nonclustered indexes with full leaf pages. It is different from 100 in that SQL Server leaves some space within the upper level of the index tree. There is seldom a reason to change the default fill factor value because you can override it with the CREATE INDEX statement. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>