How to Change a Fill Factor
The fill factor is an advanced option on a SQL Server 2000 put out by Microsoft. By adjusting fill factors, you can determine what percentage of an index is filled before it is split into multiple pages. By dividing the data into various pages, the overall server runs at an optimal speed. A fill factor can be anywhere from 0 to 100.
Other People Are Reading
Instructions
-
-
1
Open the server control panel by choosing the server you want to work with from the networked list on your computer’s hard drive. The computer you are using will need administrative authority in order to access the controls of the server.
-
2
Access the sp_configure system from the drop down file menu. This allows you to access the advanced options area.
-
-
3
Choose “show advanced options” from the editing drop down menu. Make sure the value is set to “1,” and if it is not, change it to “1.”
-
4
Shut down the server. You can either do this from the computer or by turning the machine off. It is recommended to shut it down from your control panel as to make sure all open programs close prior to shutting the system down.
-
5
Restart the server. This allows the changes to take effect, so your “show advanced options” should now read “1.”
-
6
From the format drop down menu choose the “fill factor” line and adjust the fill factor to the number you wish it to be.
-
1
Tips & Warnings
You do not usually need to change the default fill factor because you can always override the fill factor by creating a new index statement. You then choose the fill factor for the server.
References
- Photo Credit Thinkstock Images/Comstock/Getty Images
