- The time interval of the index reconstruction task must be relatively consistent.
- If the index is small, there is no need to adjust the fill factor.
- Monitoring and updating at the index level, rather than at the table level.
- Save the filling until 0, or between 75 and 100. If you want to set the fill factor to below 75, you must be confident in what you are doing. Maintaining a lower scan density and a lower average page density is very important. Make some observations to find out how frequently the table is read before reducing the value of the fill factor.
- If scan density is higher than or equal to 90%, do not change the fill factor, or adjust the fill factor in the task at least should not be adjusted first.
- If scan density is between 60% and 90%, reduce the fill factor slightly, for example, by 2%.
- If scan density is lower than 60%, the padding factor is increased and decreased. The value of fill factor is usually the value between the average page density and the initial fill factor. For example, if original fill factor = 100 and average page density = 60, then the fill factor is 80.
- If the average page density is greater than the original fill factor and the scan density is close to 100%, increase the fill factor value. This is good because you can put more data on the same page. For example: Fill Factor = 80, scan density = 98, average page density = 88. At this point, before the next index reconstruction, the page is filled at a speed of 8%, and the speed is relatively stable. In this case, you can increase the value of the fill factor, but not more than 92. Due to the growth rate of 8%, the page will be immediately filled to 100%, resulting in page splitting. I suggest increasing it to 88% and starting to observe the next data change.
- Try to avoid changing the fill factor too quickly. I suggest you observe more cycles and then fine-tune them.
Http://hi.baidu.com/stiveny/blog/item/b6e0182989de75f898250a55.html