Post reply

Indexes that will not defrag -

  • July 17, 2006 at 12:37 am

    #173383

    Pardon what may be a newb type question -

    I've a DB with a number of indexes that are highly fragmented(>75%). I've tried GUI tools via Management Studio and scripted methods of defragging these indexes, but they will NOT defrag.

    Is there something that might prevent these indexes from being defragged that is not readily apparent ?

     

    Thanks !

  • July 17, 2006 at 1:04 am

    #649462

    Hi Randy,

    How big are the tables? If there are few rows in the table then the fragmentation level can appear to be high. With small tables though the fragmenation figure is not very meaningful.

    Do the tables have clustered indexes on them?

    Karl
    source control for SQL Server

  • July 18, 2006 at 7:31 am

    #649775

    try defragging your filesystem also.

  • July 19, 2006 at 2:30 am

    #650029

    the default fill factor may be set on the database, in that case rebuilds will retain the fill factor. Other than that small indexes of few pages sometimes will not show as being defragged, these normally show up as 25%, 50% or 33% ( in my experience )

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply