Post reply

DBCC SHOWCONTIG WITH TABLERESULTS, ALL_INDEXES question

  • December 12, 2008 at 12:13 pm

    #71692

    If I run DBCC SHOWCONTIG WITH TABLERESULTS, ALL_INDEXES against my SQL Server 2000 database and see High Extent Fragmentation and logical Fragmentation numbers, what is the recommended way to remedy this??

  • December 12, 2008 at 12:18 pm

    #911872

    rebuild indexes.

  • December 12, 2008 at 1:32 pm

    #911900

    Thanks!

    I did a DBREINDEX on all tables in my DB (individually) using this format:

    use MYDB

    DBCC DBREINDEX ('MYDB.Territories', '', 70)

    After doing this, the logical fragmentation and extent fragmentation numbers are still VERY high.. like 98 and 99%????

  • December 12, 2008 at 6:40 pm

    #911982

    DBCC SHOWCONTIG WITH TABLERESULTS, ALL_INDEXES

  • December 15, 2008 at 4:08 am

    #912363

    As per books online:

    Logical Scan Fragmentation Percentage of out-of-order pages returned from scanning the leaf pages of an index. This number is not relevant to heaps and text indexes.

    Extent Scan Fragmentation Percentage of out-of-order extents in scanning the leaf pages of an index. This number is not relevant to heaps.

    You should not consider these numbers for heaps. In the sheet attached by you this can be easily depicted.

    MJ

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

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