Comments
4 comments
-
You can't change it down to a single instance level, but as per that thread you posted it can be done globally to change the time the sampler runs.
Run C:\Program Files\Red Gate\SQL Monitor\BaseMonitor\ConfigurationFileEditor.exe as an administrator, and look for %ProgramData%\Red Gate\SQL Monitor, which might be hidden by default? -
Thanks, @Russell D. Unfortunately, we run index re-orgs and rebuilds on different nights for different servers (same as when full backups run). If I move it for one server, the next one will probably bubble up. It would be nice if we could change this setting at a per-instance grain.
-
Oddly, when I go to the Redgate User Voice page, there is no category for SQL Monitor.
https://redgate.uservoice.com/forums/602209-redgate
-
Not sure why that is, I'll pass that on to the webteam. Here it is: https://sqlmonitor.uservoice.com/forums/91743-suggestions.
Add comment
Please sign in to leave a comment.
I rebuild indexes on one of our SQL Server instances on Wednesday nights. I'd like the SQL Monitor fragmented index check to occur after that - for that server only. I have seen:
https://forum.red-gate.com/discussion/83144/is-it-possible-to-change-the-time-when-the-fragmented-indexes-check-is-run
I did not find this config file on the SQl Monitor server. I found a similarly named config file, though, but it did not have a <schedule> element.
This is not a big deal since I just set the alter to be "low" instead of medium. Plus, I know that I am Ola Hallengrenning (yes, I verbified Hallengren) all my DBs, so I could probably just turn this alert off. However, it would still be nice to be able to config the alert schedule.