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.

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
1  
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

 
discard

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

Browse other questions tagged or ask your own question.