Post reply

Index Fragmentation

  • December 19, 2008 at 3:47 am

    #128758

    Hello all,

    I have a question :

    I have an Index with a 85% total fragmentation. I rebuilt this index but the fragmentation is still at 85%.

    Someone could explain me why?

    Many thanks.

  • December 19, 2008 at 4:49 am

    #915117

    Is it nonclustered index on a heap (= table without a clustered index)?

    Is it a very small table, with only few pages?

    What is the fillfactor?

  • December 19, 2008 at 6:03 am

    #915164

    Hello Suresh,

    thanks for your answer.

    no it's a clustered Index and Yes it is a small table.

    The fillfactor is 90.

    Xavier

  • December 19, 2008 at 6:44 am

    #915208

    This is a known issue on really small tables. In some cases the fragmentation will actually go up after a rebuild. I have a bookmark at home that explains why this occurs that I'll post on here tonight, but what you are seeing is normal. The fragmentation also is not problematic in general terms for small tables.

    Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
    My Blog | Twitter | MVP Profile
    Training | Consulting | Become a SQLskills Insider
    Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]

  • December 19, 2008 at 8:02 am

    #915311

    Thank you very much Jonathan

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply