On some of my high transaction tables. I run a job which reindex's the
table to a fill factor that will have the table almost at %100 at the end
of the business day.
I have found this to be quite effective.
__________________________________________
Anthony Hand
DBA | Systems Integration
Aon Risk Services Australia Ltd
Ph: +61 2 9253 7516
Fax: +61 2 92537952
"Daylinda Sanchez"
<Daylinda.[Email Address Removed] To: "LazyDBA.com Discussion" <[Email Address Removed]
lmer.co.nz> cc:
Subject: Index fill factor
30/04/2004 09:03 AM
Hi there,
Can anyone please advise/share how you handle your fill factor settings?
Currently, I am looking at a database (20 GB) size and there are at least
10 transactional tables in it. The current fill factor is set to default
which is 0. In BOL it says, every time the indexes are being rebuilt, it
will set the index page to 100% full thus creating page splits everytime a
new data is inserted.
I am running DBreindex once a week too. Is this efficient enough?
Daylinda Sanchez
We should be taught not to wait for inspiration to start a thing. Action
always generates inspiration. Inspiration seldom generates action.
-- Frank Tibolt
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.634 / Virus Database: 406 - Release Date: 18/03/2004
----------
The information contained in this e-mail and any attachments is
confidential
and is intended for the attention and use of the named addressee(s) only.
Any views expressed in this message are those of the individual sender and
may not necessarily reflect the views of Chelmer Limited.
"The information contained in this email and any attached files ("Email")
is strictly private and confidential. This Email should be read by the
intended recipient only. If you are not the intended recipient of this
Email or if you believe this is an unsolicited email, please immediately
notify the sender by replying to this email or contact a representative
from the Aon Group of Companies ("Aon") on +61 2 9253 7000 and promptly
destroy this Email and any copies of this Email.
Only the intended recipient of this Email may use, reproduce, disclose or
distribute the information contained in this Email with Aon's permission.
If you are not the intended recipient, you are strictly prohibited from
using, reproducing, disclosing or distributing the information contained in
this Email.
Aon does not represent, warrant or guarantee that the integrity of this
Email has been maintained or that the communication is free of errors,
virus or interference. Aon advises that this Email should be scanned to
detect viruses. Aon accepts no liability for loss or damage (whether
caused by negligence or not) resulting from the use of this Email.
Unless the sender is expressly providing you with personal advice, any
advice contained in this Email has been prepared without taking into
account your objectives, financial situation or needs. Before acting on any
advice in this Email, you should consider whether that advice is
appropriate for your personal circumstances. If this Email contains
reference to any specific financial product(s), Aon recommends you consider
the relevant product disclosure statement or other disclosure document(s)
before making any decision regarding that product."
MS Sql Server LazyDBA home page