Posted by John Bell on 03/11/07 10:36

Hi Rob

"rcamarda" <robert.a.camarda@gmail.com> wrote in message
news:1173578291.621286.217970@p10g2000cwp.googlegroups.com...
> thanks John:
> Result of one trouble file (tab delimited).
> alloc_unit_type_desc index_depth index_level
> avg_fragmentation_in_percent fragment_count avg_fragment_size_in_pages
> page_count
> IN_ROW_DATA 1 0 33.3333333333333 12 11.1666666666667 134
> IN_ROW_DATA 2 0 88.2352941176471 16 1.0625 17
>
> Based on your points about BOL, I found a script the reindex, or reorg
> the index, but I still have files upwards of 80% fragmentation.
> This is an undiscovered country for me, thanks for the guidance!
> Rob
>

There seems to be some columns missing! Can you also post the DDL for the
table and indexes.

John

• Next in forum: MSSQL 2005 SP2 install error 2259 - what gives?
• Prev in forum: Re: Transaction Logs
• Thread view: Re: index fragmentation LogicalFragmentation -how bad is bad - silly question alter

[Reply to this message]