From MOC833 (SQL Server 7 Design and Implementation) Lab 5.2 ******************* Base table of 52000 rows - No FILLFACTOR ******************** **** No fragmentation but pages full so will get fragmented if add more rows **** DBCC SHOWCONTIG scanning 'loanhist' table... Table: 'loanhist' (293576084); index ID: 1, database ID: 8 TABLE level scan performed. - Pages Scanned................................: 453 - Extents Scanned..............................: 57 - Extent Switches..............................: 56 - Avg. Pages per Extent........................: 7.9 - Scan Density [Best Count:Actual Count].......: 100.00% [57:57] - Logical Scan Fragmentation...................: 0.00% - Extent Scan Fragmentation....................: 1.75% - Avg Bytes Free per Page......................: 58.7 - Avg. Page Density (full).....................: 99.28% DBCC execution completed. If DBCC printed error messages, contact your system administrator. ******************* Added 26000 rows - No FILLFACTOR ******************** ************************** heavily fragmented *************************** DBCC SHOWCONTIG scanning 'loanhist' table... Table: 'loanhist' (293576084); index ID: 1, database ID: 8 TABLE level scan performed. - Pages Scanned................................: 905 - Extents Scanned..............................: 118 - Extent Switches..............................: 903 - Avg. Pages per Extent........................: 7.7 - Scan Density [Best Count:Actual Count].......: 12.61% [114:904] - Logical Scan Fragmentation...................: 99.78% - Extent Scan Fragmentation....................: 2.54% - Avg Bytes Free per Page......................: 2060.9 - Avg. Page Density (full).....................: 74.54% DBCC execution completed. If DBCC printed error messages, contact your system administrator. ******************* Base table of 52000 rows with FILLFACTOR 45 ******************** ******************** Page less than half full to start with ************************ DBCC SHOWCONTIG scanning 'loanhist' table... Table: 'loanhist' (293576084); index ID: 1, database ID: 8 TABLE level scan performed. - Pages Scanned................................: 982 - Extents Scanned..............................: 123 - Extent Switches..............................: 122 - Avg. Pages per Extent........................: 8.0 - Scan Density [Best Count:Actual Count].......: 100.00% [123:123] - Logical Scan Fragmentation...................: 0.00% - Extent Scan Fragmentation....................: 0.81% - Avg Bytes Free per Page......................: 4387.3 - Avg. Page Density (full).....................: 45.80% DBCC execution completed. If DBCC printed error messages, contact your system administrator. ******************* Added 26000 rows with FILLFACTOR 45 ********************* *** Since the page was less than half full, plenty of room to add new rows*** DBCC SHOWCONTIG scanning 'loanhist' table... Table: 'loanhist' (293576084); index ID: 1, database ID: 8 TABLE level scan performed. - Pages Scanned................................: 982 - Extents Scanned..............................: 123 - Extent Switches..............................: 122 - Avg. Pages per Extent........................: 8.0 - Scan Density [Best Count:Actual Count].......: 100.00% [123:123] - Logical Scan Fragmentation...................: 0.00% - Extent Scan Fragmentation....................: 0.81% - Avg Bytes Free per Page......................: 2533.9 - Avg. Page Density (full).....................: 68.69% DBCC execution completed. If DBCC printed error messages, contact your system administrator.