November 25, 2016 at 2:21 am
Dear All,
I have an index job which Reorganises or rebuild indexes depending on the level of the defragmentation level but when I run the query for the fragmentation levels after the Index job has completed, some of the fragmented levels are as high as 90% would any let me know the reason why this is the case please?
Thank you in advance.
November 25, 2016 at 2:28 am
For small indexes, rebuilding or reorganising won't make any difference to fragmentation levels. Because of the size of such indexes, the fragmentation level has little or no impact on performance. You should therefore consider excluding them from your maintenance job. Start with a threshold of 1000 pages and see how that goes.
John
November 25, 2016 at 4:08 am
Thank you for your reply! To give you as example of the results, the fragmentation percentage for one of the indexes is 85%, the index type is nonclustered, the page count is 15 and avg fragment size in page is 1 and I am trying to understand the reason why the fragment level is so high and the meanings of the other values e.g the fragment type etc. please?
November 25, 2016 at 4:19 am
The reason the fragmentation level is so high is merely academic. For a 15-page index, it really doesn't matter. As for the other numbers you mentioned, I can't see your results, nor even the query you ran to get them, so I can't categorically tell you what any of them mean.
John
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply