Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I can't think of any reason why you couldn't change the fill factor on the table without any issues, but I've never changed the fill factor on a system table before and would like to know if anyone has done this.

We are seeing 70% fragmentation by the afternoon and would like to lower the fill factor by 10% as we have some heavy replication going on.

share|improve this question
How often are you rebuilding indexes? A FILLFACTOR only takes effect on a rebuild. – Nick Chammas Sep 16 '11 at 16:38
From what I read "we are seeing 70% fragmentation by the afternoon" - you mean that in the morning it's ok and in the afternoon fragmentation is 70%? Do you defragment your indexes daily? – Marian Sep 18 '11 at 21:32
Yes we rebuild the indexes daily. just wanted to know if anyone else has amended the FILL FACTOR on the system table. – DamagedGoods Sep 19 '11 at 9:36
How big is the table? – gbn Nov 29 '11 at 19:35
Did you end up using trial and error? Did you see any performance improvement on the 10% decrease? – SQLHound May 22 '15 at 21:35

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.