Post reply

Fragmentation

  • October 20, 2015 at 4:14 pm

    #305786

    Hi All,

    I have a strange issue today.

    I have rebuilded indexes and some of the indexes still showing fragmentation percentage as 99%. I have cross checked page count for these indexes and they are more than 10000 pages.As i am aware if the page count is less we can ignore this percentage. But in my case the page count is 10000.

    Can some please let us know how to identify this issue.

  • October 21, 2015 at 2:53 am

    #1834560

    Is it an index or a heap?

    Do you have a shrink operation which ran after the rebuild?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • October 21, 2015 at 1:48 pm

    #1834765

    Its not heap.

    They are clustered and non clustered indexes.

    there is no shrink operation after rebuild.

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

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