May 14, 2012 at 7:59 pm
after I rebuild an index that has around 90% fragmentation it has no effect. The operation seem to not error.
What is happening?
thanks!
May 14, 2012 at 10:08 pm
By rebuild has no effect, do you mean fragmentation is still there?
How big is your table (in pages)?
Is it a heap?
May 14, 2012 at 10:48 pm
yes still 70% fragemented.
my table is not a heap table.
table is 11mb. I suppose that means it is 1375 pages big.
May 15, 2012 at 12:22 am
yeah thats pretty good tool! Index is not reported as a problem
May 15, 2012 at 12:22 am
djordan 41144 (5/14/2012)
yes still 70% fragemented.my table is not a heap table.
table is 11mb. I suppose that means it is 1375 pages big.
That is a very small table. In general I would not worry all that much about fragmentation of a table with that few pages. I would be interested in seeing the table definition including all indexes on the table. Can you please provide those?
__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
May 15, 2012 at 1:52 pm
What is the FillFactor for the index?
Also what type of data is in the index?
May 16, 2012 at 4:54 am
djordan 41144 (5/14/2012)
after I rebuild an index that has around 90% fragmentation it has no effect. The operation seem to not error.
defragmentation generally dosesnt work for small table (1000 data pages) but in your case index rebuild should have reduced the fragmentation percantage down.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
Viewing 8 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply