index rebuild no effect

  • djordan 41144

    SSC Journeyman

    Points: 92

    after I rebuild an index that has around 90% fragmentation it has no effect. The operation seem to not error.

    What is happening?

    thanks!

  • Suresh B.

    SSC-Insane

    Points: 22986

    By rebuild has no effect, do you mean fragmentation is still there?

    How big is your table (in pages)?

    Is it a heap?

  • djordan 41144

    SSC Journeyman

    Points: 92

    yes still 70% fragemented.

    my table is not a heap table.

    table is 11mb. I suppose that means it is 1375 pages big.

  • Dugi

    SSCoach

    Points: 17998

    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/[/url]

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

  • djordan 41144

    SSC Journeyman

    Points: 92

    yeah thats pretty good tool! Index is not reported as a problem

  • Orlando Colamatteo

    SSC Guru

    Points: 182269

    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

  • DBA_Dom

    SSCrazy

    Points: 2842

    What is the FillFactor for the index?

    Also what type of data is in the index?

  • Bhuvnesh

    SSC Guru

    Points: 59344

    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