Post reply

Extents Allocated > 200

  • January 24, 2008 at 10:04 am

    #69710

    We are running a DB performance monitor. It shows extents allocated >200. We run DBCC SHOWCONTIG on a table and shows:

    Scan density is 20%

    Logical Scan Fragmemtation is 40%

    Extent Scan Fragmentation is 77%

    others show:

    Scan density is 66%

    Logical Scan Fragmemtation is 0%

    Extent Scan Fragmentation is 66%

    Is there a problem here and if so how do I fix? We have run DBCC REINDEX on the tables but it did not correct the numbers.

    thanks,

  • January 24, 2008 at 11:31 am

    #771432

    You might want to run a DBCC UPDATEUSAGE to ensure you're still receiving the correct numbers.

  • January 24, 2008 at 11:34 am

    #771433

    That's the scary part, we did run updateusage!!!

  • January 24, 2008 at 11:39 am

    #771436

    Does this table have a clustered index? Because heaps (tables without a clustered index) essentially can't be defragmented: the only way to approximate it is to create another table and copy all records into the new table.

    ----------------------------------------------------------------------------------
    Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

  • January 24, 2008 at 12:01 pm

    #771448

    Great, thanks, there are no clustered indexes on the table.

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

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