How to Use

Run the following query against a database:
exec sp_MSforeachtable @command1="print '?' DBCC showcontig ('?')"
Paste the results into the box below, set the thresholds (or accept the defaults), and click Analyze.
If necessary, rebuild the indexes with the following query:
exec sp_MSforeachtable @command1="print '?' DBCC DBREINDEX ('?')"
Filter Thresholds
Scan Density:‹ %
Logical Scan Fragmentation:› %
Extent Scan Fragmentation:› %
Show All Indexes: