Sample Header Ad - 728x90

Is high Extent Fragmentation a problem?

7 votes
2 answers
11228 views
DBCC SHOWCONTIG scanning 'MyTable' table... Table: 'MyTable' (2048062382); index ID: 1, database ID: 28 TABLE level scan performed. - Pages Scanned................................: 1019182 - Extents Scanned..............................: 127400 - Extent Switches..............................: 127399 - Avg. Pages per Extent........................: 8.0 - Scan Density [Best Count:Actual Count].......: 100.00% [127398:127400] - Logical Scan Fragmentation ..................: 0.01% - Extent Scan Fragmentation ...................: 77.25% - Avg. Bytes Free per Page.....................: 135.7 - Avg. Page Density (full).....................: 98.32% I have read that Scan Density = 100% is very good, and Logical Scan Fragementation <1% is also great. 77% Extent Scan Fragmentation troubles me, but the internet says to ignore it. I'm analyzing a single-table slow performing query. It runs ~30 seconds on first execution, then 200 ms on second and subsequent executions. I can reset this behavior with DBCC DROPCLEANBUFFERS. Is the high Extent Scan Fragmentation an important clue? (If not, I'll likely add another question about my single-table query).
Asked by Amy B (241 rep)
Apr 16, 2013, 04:24 PM
Last activity: Apr 6, 2023, 12:38 AM