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
Last activity: Apr 6, 2023, 12:38 AM