January 27, 2004 at 6:36 am
I use a maintenance plan to reorganize a database in SQL2000.
On the optimisations tab is defined, that the data and index pages should be reorganised with the original amount of free space.
The outputlisting of the job contains the next line:
[1] Database HDMdb: Index Rebuild (leaving 100%% free space)...
Can anyone tell me what 100%% means ???
Regards
Rob
January 27, 2004 at 8:45 am
When creating an index, you can specify a fill factor to leave extra gaps and reserve a percentage of free space on each leaf level page of the index to accommodate future expansion in the storage of the table's data and reduce the potential for page splits. The fill factor value is a percentage from 0 to 100 that specifies how much to fill the data pages after the index is created. A value of 100 means the pages will be full and will take the least amount of storage space. This setting should be used only when there will be no changes to the data, for example, on a read-only table.
The default for fill factor is 0; valid values range from 0 through 100. A fill factor value of 0 does not mean that pages are 0 percent full. It is treated similarly to a fill factor value of 100 in that SQL Server creates clustered indexes with full data pages and nonclustered indexes with full leaf pages.
What is your server fill factor setting? You can get it from sp_configure.
January 27, 2004 at 9:10 am
My server fill factor is 0
The fill factor for almost all indexes is 90
January 27, 2004 at 10:53 am
Your first post said "leaving 100% % free." Is that accurate?
"Keep Your Stick On the Ice" ..Red Green
January 28, 2004 at 1:32 am
Yes, that is accurate.
And that is what I don't understand.
The output line says:
[1] Database HDMdb: Index Rebuild (leaving 100%% free space)...
I expected that the outputline should be like this:
[1] Database HDMdb: Index Rebuild (leaving 10% free space)...
So the question is: What does 100%% mean ?
October 11, 2005 at 12:51 pm
I have the same question.
If my fill factor is set to the default of 0, shouldn't the log message say "(leaving 0% free space)" ?
how can you leave 100% free space? wouldn't the index be empty?
Regards, Jim C
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply