Post reply

High_Extent Scan Fragmentation

  • February 9, 2009 at 12:17 am

    #77252

    Hi,

    I rebuild the DB on sunday using following query

    EXEC sp_MSforeachtable @command1="print '?' DBCC DBREINDEX ('?','', 80)"

    GO

    EXEC sp_updatestats

    but Today I saw the Extent Scan Fragmentation not reduce.

    Please any one assist me.

    sql-2000 standard win-2003 standard

    DBCC SHOWCONTIG scanning 'Import_Log' table...

    Table: 'Import_Log' (21575115); index ID: 4, database ID: 26

    LEAF level scan performed.

    - Pages Scanned................................: 8

    - Extents Scanned..............................: 6

    - Extent Switches..............................: 5

    - Avg. Pages per Extent........................: 1.3

    - Scan Density [Best Count:Actual Count].......: 16.67% [1:6]

    - Logical Scan Fragmentation ..................: 0.00%

    - Extent Scan Fragmentation ...................: 83.33%

    - Avg. Bytes Free per Page.....................: 2261.0

    - Avg. Page Density (full).....................: 72.07%

    DBCC execution completed. If DBCC printed error messages, contact your system administrator.

    Thanks,

    Muthu

    Muthukkumaran Kaliyamoorthy
    https://www.sqlserverblogforum.com/

  • February 9, 2009 at 10:16 am

    #940635

    You need not execute sp_updatestats after rebuild command as it gets executed in background by this command. Index looks to be of very small size but if you still want to reduce the extent fragmentation then better export data out from table, create new table, import data there and drop the old table.

    MJ

  • February 9, 2009 at 10:54 pm

    #940984

    MANU,

    Thanks for ur reply This is Production Database the developer are using daily and We have low disk Space.

    Is there any other way?

    Thanks,

    Muthu.

    Muthukkumaran Kaliyamoorthy
    https://www.sqlserverblogforum.com/

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

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