Post reply

How to resort to default fill factor after changes

  • October 20, 2003 at 9:01 am

    #59850

    Hi

    I changed the fill factor from whatever the default should be to 90 (Testing).

    Each time the indexes are rebuilt without a specification the fillfactor defaults to 90.

    How do I get back to the default ......

    Tried 100 and 0 and everything still defaults to 100 n.

    I use sp_Msforeachtable to rebuild them

    Thanks

    Mike

  • October 20, 2003 at 2:30 pm

    #478867

    to set the system wide default fill factor try:

    EXEC sp_configure -- checks current settings

    -- to change system wide fill factor

    EXEC sp_configure 'fill factor (%)' ,0

    RECONFIGURE

    -- verifies fill factor changed

    EXEC sp_configure

    Francis

  • October 21, 2003 at 3:20 am

    #478905

    I meant during an index rebuild

  • October 21, 2003 at 7:18 am

    #478943

    Try user CREAT INDEX command with index option FILLFACTOR = fillfactor to recreate your index.

  • October 22, 2003 at 12:22 pm

    #479160

    I did rebuild the indexes with a fill factor of 0 from 90 after accidentally writing 100 in place of Zero.

    Right now the origfillfactor shows as 100 I have been worried because of a lot of testing taking place, but so far all looks good . When I had a fill factor of 90 there were lots of locking issues but with 100 as it is today there is almost non.This is not a complain but seems contrary to my understanding of how the fill factor works.

    There are definitely updates ,inserts and deletes.Any ideas will be appreciated

  • October 22, 2003 at 12:36 pm

    #479164

    what kind of index, clustered or nonclustered?

    try "DBCC DBREINDEX".

    Edited by - simon_hyan on 10/22/2003 12:45:02 PM

  • October 22, 2003 at 12:49 pm

    #479171

    The indexes are clustered for the most part.

    Would that make a lot of a difference?

  • October 22, 2003 at 12:57 pm

    #479177

    Difference is the page spliting.

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply