Problem Statement 1 :I have been using ola hallengren's script on the below link for index maintenance. HOwever I have noticed that its not working as expected(Noticed this after a long time though after the performance was degraded
I have a number of fragmented indexes which are not getting rebuilt or reorganized inspite of providing the correct parameters
My job script was as below :
@Databases = 'MY_DB_Name',
@FragmentationLow = NULL,
@FragmentationMedium = 'INDEX_REORGANIZE,INDEX_REBUILD_ONLINE,INDEX_REBUILD_OFFLINE',
@FragmentationHigh = 'INDEX_REBUILD_ONLINE,INDEX_REBUILD_OFFLINE',
@FragmentationLevel1 = 5,
@FragmentationLevel2 = 20,
@UpdateStatistics = 'ALL',
@OnlyModifiedStatistics = 'Y'
I have attached a detailed report of the fragmentation levels before and after the script was run and there was no difference except that only one table was taken care of and this has been happening since a long time.
I have also verified the row count for the tables are more than 1000 in most of the cases...
Is there anything wrong that I am doing?
Problem statement 2 : For the above problem, I created a maintenance plan(Rebuild offline) for rebuilding all indexes and the result was better than that previous one(The one with Ola hallengrens script), however, there were still some indexes which were left over. I ran the maintenance Plan over and over again
, however, they still remain the way they are..
I have attached the list for the maintenance Plan before and after report as well.
Can someone please tell me if this is a default behaviour of both these approaches to skip some fragmented indexes? If yes then on what filter criteria?
Thanks in advance...