Configurable time for fragmented indexes alert run
I would like an GUI option to configure the time the alert fragmented indexes run instead of it being set at 1.00am Sunday morning
Note that this can set in the BaseMonitor .config file
-
Thanks Mike for your feedback.
-
Mike Fal commented
I would like to see this exposed in the GUI and be able to schedule it beyond once a week. Ideally, you can create/set a schedule for fragmentation scan per instance.
-
Priya Sinha commented
Hi Andrew .. I have just emailed you. Let me know if you have not received the email.
-
Andrew Hodge commented
Any documentation on how to change the configuration file? I dont think I would be need to configure this option per server.
-
Priya Sinha commented
Thanks Andew. The current SQL Monitor released version supports changing the day-time for Index fragmentation checks. Though it is not exposed on UI but can be changed in configuration file.
Would exposing this to UI is enough or do you think that this configuration should be supported per SQL Server?