March 25, 2014 at 8:12 am
Hi all,
I know this is a pretty common question, but I can't seems to find an answer anywhere....
I am trying to defrag a number of indexes using the following criteria:
Reorganise indexes with 5-30% fragmentation
Rebuild indexes with > 30% fragmentation
Indexes with over 1000 pages only
The problem is, after the defrag has run there doesn't appear to be much change in any of the fragmentation levels - could anyone explain why this is? I know very small indexes will often not change, but these are all indexes with over 1000 pages, some with fragmentation levels of 98%+
Any ideas why this can happen?
Cheers
Matt
March 25, 2014 at 9:03 am
can you post the output from sys.dm_db_index_physical_stats to give us more information to go on?
March 25, 2014 at 9:07 am
About how many pages are in the indexes you are noticing this on?
Are the tables heaps?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 25, 2014 at 9:20 am
Sorry I might have been a bit premature posting this - it appears my monitoring tool was not refreshing correctly. After a bit more in-depth investigation it looks like the indexes were indeed correctly defragmented....thanks for looking though!!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply