Tuning SQL Server’s Fill Factor Setting for Indexes and Performance When it comes to optimizing the performance of a SQL Server, setting the fill factor on indexes can seem like a dark art to both new and experienced database administrators.