September 22, 2008 at 3:37 am
HI ALL
I have facing an arbite problem of fragmentation
the problem senario I have a table with <500 records when i rebuild the index on it then it gives when i run dbcc showcontig
Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
Logical Scan Fragmentation ..................: 0.00%
Extent Scan Fragmentation ...................: 0.00%
now when i again rebuild the index on it then it gives when i run dbcc showcontig
Scan Density [Best Count:Actual Count].......: 50.00% [1:2]
Logical Scan Fragmentation ..................: 50.00%
Extent Scan Fragmentation ...................: 0.00%
now when i again rebuild the index on it then it gives when i run dbcc showcontig
Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
Logical Scan Fragmentation ..................: 0.00%
Extent Scan Fragmentation ...................: 50.00%
now when i again rebuild the index on it then it gives when i run dbcc showcontig
Scan Density [Best Count:Actual Count].......: 100.00% [1:1]
Logical Scan Fragmentation ..................: 0.00%
Extent Scan Fragmentation ...................: 0.00%
So could you plz suggest what i have to do becaz i ran dbcc dbreindex, dbcc dbrepair, dbcc indexdefrag
September 22, 2008 at 4:30 am
its because the table is so small. You should ignore fragmentation results for tables less than 1000 rows
September 22, 2008 at 4:36 am
hello
is there any way to resolve the problem....... we cant ignore it. its create problem
Animal Magic (9/22/2008)
its because the table is so small. You should ignore fragmentation results for tables less than 1000 rows
September 22, 2008 at 4:52 am
what problem are you getting?
September 22, 2008 at 5:07 am
Animal Magic (9/22/2008)
what problem are you getting?
i want this result. after rebulding the iindex
Logical Scan Fragmentation ..................: 0.00%
Extent Scan Fragmentation ...................: 0.00%
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply