increase or decrease the fill factor
Dear team.
I see some explanation on the sql Monitor live Demo tool which seems incorrect:
Check also: The fill factor percentage of the tables in your indexes. If enough space for index expansion is available on data pages, the potential for page splits is reduced. The default fill factor value setting is 0 (100%), which means that pages are filled to capacity. If you increase the fill factor, additional free space is left in the indexes after they are rebuilt or reorganized, helping to prevent excessive page splitting
increase should be decrease: the higher the fill factor the less free space remains.
Best regards Patrick van Older
-
Thanks for letting us know about this Patrick, I'll add this into our bug tracking system to be sorted out.