Why IndexOptimize cannot reduce fragmentation of clustered index? RRS feed

  • Question

  • Hello experts,
    I have some databases in different servers and found the fragmentation numbers are over 90% on the indexes in some tables. Then, the jobs with master database stored procedure:

    EXECUTE [dbo].[IndexOptimize] @Databases = '(my each database name)', @Indexes = '(my each index name)', @FragmentationLow =NULL, , @FragmentationMedium = 'INDEX_REORGANIZE,INDEX_REBUILD_ONLINE', @FragmentationHigh = 'INDEX_REORGANIZE,INDEX_REBUILD_ONLINE', @FragmentationLevel1 = 5, @FragmentationLevel2 = 30 , @LogToTable = 'Y' 

    was setup and run successfully. This stored procedure works on some indexes, the fragmentation numbers were down. But, some indexes still have >90% fragmentation.

    Why this stored procedure works on some indexes but not on some others? Is there other way to bring Fragmentation down?



    • Edited by LW1990 Friday, September 20, 2019 8:28 PM
    Friday, September 20, 2019 8:27 PM

All replies