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-FragmentedindexesThere 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!
Tips and how-to guides for Redgate products
Ask, discuss, and solve questions about Redgate's tools
Meet us at an event, get sponsored, and join our Friends of Redgate
In-depth articles and opinion from Redgate's technical journal