Re: Fill Factor

Tech-Archive recommends: Speed Up your PC by fixing your registry

My guess would be that someone set up a maintenance plan that reindexes the tables and has the fill factor set to 90 there. But why would this cause problems? I would think it would eliminate more problems than it would cause. Having the fill factor at 0 means that each leaf level is essentially 100% full and any additional insert or update with more bytes than before will cause a page split. With a Fill Factor of 90 you at least have some room to operate and still minimize page splits.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"Saeed Abd Al-Ati" <SaeedAbdAlAti@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:92FA67B7-FAAC-4F74-9F3D-4F4CEEB81DF4@xxxxxxxxxxxxxxxx
Hi,

I am facing a Weird problem in configuring the Fill Factor for my production
database, i deployed a database to a client and sit the Fill Factor for all
indexes to be "0" which is the default value, after 1 week the value changed
to be "90" which caused some problems in the application, since there are
some problems in HD allocations, my question is: how this value changed
automatically? taking into consideration that there is no specific
devleopment/administration script applied on the Database.

Thanks in advance.

.

Relevant Pages

  • Re: Event log error message: Database log truncated: Database
    ... our maintenance plan combines both master and the User ... It also selects Transaction Log Backup option. ... Select Recovery mode Simple for master. ... Select all options (Reorganize data and index pages, check database ...
    (microsoft.public.sqlserver.server)
  • Re: Event log error message: Database log truncated: Database
    ... our maintenance plan combines both master and the User ... It also selects Transaction Log Backup option. ... back up the database as part of the maintenance plan and etc) ...
    (microsoft.public.sqlserver.server)
  • Re: ALTER DATABASE (optimization job)
    ... It sounds like you are using the database maintenance plan to reindex, ... Your plan to change the recovery model won't necessarily work. ... > When this night run occurs, the transaction log on my database increases to ...
    (microsoft.public.sqlserver.tools)
  • Re: ALTER DATABASE (optimization job)
    ... It sounds like you are using the database maintenance plan to reindex, ... Your plan to change the recovery model won't necessarily work. ... > When this night run occurs, the transaction log on my database increases to ...
    (microsoft.public.sqlserver.programming)
  • Re: ALTER DATABASE (optimization job)
    ... It sounds like you are using the database maintenance plan to reindex, ... Your plan to change the recovery model won't necessarily work. ... > When this night run occurs, the transaction log on my database increases to ...
    (microsoft.public.sqlserver.server)