SQL Server 2000 re-index

Question

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

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

Steve Jones - SSC Editor SSC Guru Points: 738848 More actions · Answer 1

Use dbcc showcontig to check fragmentation. There isn't logging for defragmenting.

Moved to SQL 2000

Ed7 SSCrazy Eights Points: 8519 More actions · Answer 2

Hi Steve,

I run DBCC SHOWCONTIG ('dbo.FaultTables')

GO

Results:

--- Scan Density 81.31%

--- Logical Fragmentation 1.56%

--- Extent Scan Fragmentation 34.82%

--- Avg. Bytes Free per page 2219.6

--- Avg Page Density (Full) 72.58%

Base on the above results.

Can the above results indicate that dbo.Faulttable all ready reindex?

Thanks,

Edwin