How can we help you today? How can we help you today?

Fragmented Index Recommendation doesn't obey changes

I changed the default rule for my recomendation.
----
Default Template \ Fragmented Index

[ ] Disabled
[x] Enabled

Index Fragmentation more than [50]%

Only check indexes with more than [1000] pages.

[Save Changes]
----

The problem is that it's been a few hours. The recommendation has been checked a few times and I'm still seeing recommendations for fragmented indexes with less than 1000 pages.

I've gone back to confirm that my change is there by clicking [Edit Recommended Configuration]. My settings are there for the individual database, server, and default template.

The reason I want to increase to 1000 pages is because as soon as I rebuild indexes, they quickly show up again after a couple days. Most indexes have between 100 and 500 pages, and probably wouldn't make much of a difference regardless if they were rebuilt or reorganized. The larger ones concern me the most (over 1000 pages).

What do I need to do to make the rule take effect with my changes?
lewismoten
0

Comments

2 comments

  • Nigel Morse
    :oops:
    A late breaking fix has been added for final release :wink:
    Nigel Morse
    0
  • lewismoten
    Thanks. I didn't try the others, but you may want to test and confirm that all other template modifications are used as well. :wink:
    lewismoten
    0

Add comment

Please sign in to leave a comment.