Fragmented Indexes Alert - How frequently is this checked?
BWar81
Posts: 7 New member
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?
Is there any way for me to make them more frequently checked?
Tagged:
Answers
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!
Tom Claringbold | Redgate Software
Have you visited our Help Center?