Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
i ran dbcc showcontig on my sql server db and it returned following
Table: 'Table1' (1621580815); index ID: 1, database ID: 7
TABLE level scan performed.
- Pages Scanned................................: 4982
- Extents Scanned..............................: 628
- Extent Switches..............................: 627
- Avg. Pages per Extent........................: 7.9
- Scan Density [Best Count:Actual Count].......: 99.20% [623:628]
- Logical Scan Fragmentation ..................: 0.00%
- Extent Scan Fragmentation ...................: 99.52%
- Avg. Bytes Free per Page.....................: 38.3
- Avg. Page Density (full).....................: 99.53%
Based on searching for info on index defrag it seems my Extent Scan
Fragmentation percentage is not what it should be (0%) . Is it true and
if yes how can you be sure that your indexes have been fragmented.
If indexes are really fragmented what is the best way without
reindexing(or is that the best way) to defrag the indexes.
Thank you
Kalpesh
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.