You are here: Re: index fragmentation LogicalFragmentation -how bad is bad - silly question alter « MsSQL Server « IT news, forums, messages
Re: index fragmentation LogicalFragmentation -how bad is bad - silly question alter

Posted by John Bell on 03/12/07 08:23

Hi Rob

On Mar 11, 4:47 pm, "rcamarda" <robert.a.cama...@gmail.com> wrote:
> John,
> I've been running the scripts you've pointed out in BOL, so they are
> changing. the amount and size of fragmentation is coming down, but I
> have some smaller files with a lot.
> fill Factor is default, which I think is 80.
>
> On Mar 11, 9:15 am, "John Bell" <jbellnewspo...@hotmail.com> wrote:
>

If your tables are bulk loaded and never change a 100% fill factor
would be feasible. If the data pages are all in memory then the index
fragmentation is not going to be an issue, this may be the case with
small tables.
To reduce fragmentation of the heap tables you can try adding a
clustered index and then drop it, although you should look at possibly
having a permanent clustered indexes in some cases.

Check the indexes are being used by seeing if there is an entry in
sys.dm_db_index_usage_stats . If there is no entry the index has not
been used since the last reboot, so you would need to see if it will
ever be usfull.

John

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация