Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
d3ng
Yak Posting Veteran
83 Posts |
 Posted - 2007-07-13 : 23:22:16
|
| Hi experts, I would like to ask regarding FILL FACTOR. I observed that our system's loading is a bit slow, and some of the modules take 1 to 2 minutes loading. Maintenance activity is regularly executed based on the scheduled sets. Then I tried to checked the tables indexes/keys turns out that the FILL FACTOR is set to ZERO(0). I would like to know if the FILL FACTOR set to zero will be a factor for the system to slow down..????Darren Bernabe Blanco |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-14 : 01:05:03
|
| How many rows to load each time? If many, youlike to set proper fill factor (say 70) to reduce index page split. |
 |
|
|
evjo
Starting Member
20 Posts |
Posted - 2007-07-14 : 01:24:10
|
| do a dbcc showcontig to see how defragged your indexes are. If they are, then it would be wise to set the fill factor to about 70, do a DBCC DBREINDEX. Index fragmentation can cause poor index performance.Whenever I see an old lady slip and fall on a wet sidewalk, my first instinct is to laugh. But then I think, what if I was an ant, and she fell on me. Then it wouldn't seem quite so funny. - Jack Handey |
|
|
|
|
|
|
Fill Factor