I'm using SQL server 2008 R2. I asked a similar question before on this forum, now I'm asking:

  • First, can I change the fill factor while the database is in use?
  • Second, how can I determine the most suitable value for our server fill factor? On what does this depend?

1 Answer 1


"yes", you can change the fill factor while the database is in use... If you can accept the blocking! I've found that it is seldom a good idea to have it different that 0 (or 100).

The dbreindex will not work on your heaps, so you should create a clustered index instead. (see for instance this Kimberly Tripps blog post or this https://www.brentozar.com/blitzindex/sp_blitzindex-self-loathing-indexes/ on "heaps with forwarded records"

You may also want to download sp_Bliz from https://www.brentozar.com/blitz/. This will help you investigate what may help your server run faster.

  • and that server is out of support. Get upgraded and use Query Store to see what the problem really is. Dec 17, 2019 at 7:21

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.