No change after DBCC INDEXDEFRAG?

I run an DBCC INDEXDEFRAG, and then rerun the DBCC SHOWCONTIG, it
seems as if nothing has changed? Shouldn't the Logical Fragmentation
percent have gone down?
Thanks!
David Hay
David
It depends on what your fragmentation values were before you ran
INDEXDEFRAG, and also it depends on how big the table is.
Can you post the before and after output?
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://blog.kalendelaney.com
"David Hay" <david.hay@.gmail.com> wrote in message
news:9db9c01f-eaea-4133-99a9-4f6172b5b080@.l6g2000prm.googlegroups.com...
>
> I run an DBCC INDEXDEFRAG, and then rerun the DBCC SHOWCONTIG, it
> seems as if nothing has changed? Shouldn't the Logical Fragmentation
> percent have gone down?
> Thanks!
> David Hay
|||Can you print the output? If this is a Heap (Indexd ID = 0) or less than 8
pages it won't do a thing.
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"David Hay" <david.hay@.gmail.com> wrote in message
news:9db9c01f-eaea-4133-99a9-4f6172b5b080@.l6g2000prm.googlegroups.com...
>
> I run an DBCC INDEXDEFRAG, and then rerun the DBCC SHOWCONTIG, it
> seems as if nothing has changed? Shouldn't the Logical Fragmentation
> percent have gone down?
> Thanks!
> David Hay
|||Thanks, that explains it. It was on a test server with very small
databases, and they all had under 8 pages.
On Jan 3, 2:50 pm, "Andrew J. Kelly" <sqlmvpnooos...@.shadhawk.com>
wrote:
> Can you print the output? If this is a Heap (Indexd ID = 0) or less than 8
> pages it won't do a thing.
> --
> Andrew J. Kelly SQL MVP
> Solid Quality Mentors
>