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:12 am
Take a look to the sweet tool from RedGate that is still free to use and let us know what happened!
http://www.red-gate.com/products/dba/sql-index-manager/%5B/url%5D
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy