Defragementation Problem

  • Respected All

    I checked one table from DMV sys.dm_db_index_physical_stats and found avg_fragmentation_in_percent was showing 80% .

    Now I Defrage this table using DBReindex but after Again i Checked and found same result (80% fragemented )

    What is problem , Why it is not defragmented.

    Thanks

    Ghanshyam

  • gupta1282 (10/13/2009)


    Respected All

    I checked one table from DMV sys.dm_db_index_physical_stats and found avg_fragmentation_in_percent was showing 80% .

    Now I Defrage this table using DBReindex but after Again i Checked and found same result (80% fragemented )

    What is problem , Why it is not defragmented.

    Thanks

    Ghanshyam

    There could be a number of reasons, how big is the table

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

Viewing 2 posts - 1 through 1 (of 1 total)

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