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%
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.