Take the 2-minute tour ×
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. It's 100% free, no registration required.

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

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.