Fragmented Indexes Alert - How frequently is this checked?

BWar81

How often are fragmented indexes checked by RedGate SQL Monitor? I have an alert from 06:10 today that is still showing as valid however the indexes in question are all below 15%.

Is there any way for me to make them more frequently checked?

Tom_C

Hi Ben,

Checking for index fragmentation is a very resource-intensive activity. For this reason, SQL Monitor only checks for fragmented indexes once a week: on Sunday at 01:00 (by default).

This means that an alert may remain Active for some time after you fix the issue, and will only be updated after the next scheduled weekly check.
https://documentation.red-gate.com/sm13/list-of-alerts-195789424.html#Listofalerts-Fragmentedindexes

There is a way to change when this runs (if you had other processes, scans etc happening in your environment that were consuming resource) but at present there isn't a way to increase frequency.

I would suggest raising this request on the UserVoice site, votes on these suggestions can help prioritise future features!