Fragmented index alert question
hbuckner
Posts: 69 Bronze 3
On my fragmented index alert, the Indexes were checked at 1:00 AM. How often are these checked and is the time configurable?
Thanks
Thanks
Comments
If you check the description for Fragmented Index on this help page you'll see an explanation as to why we collect this so infrequently. Basically it's very resource intensive:
http://www.red-gate.com/supportcenter/C ... 269920.htm
It is possible to configure this setting but currently it requires editing a config file - C:\ProgramData\Red Gate\SQL Monitor 2\RedGate.Response.Engine.Alerting.Base.Service.exe.settings.config. If you edit the following section and restart the base monitor service it should pick up the new settings:
If you wish to go ahead and increase how often this is checked then I could find out some more details.
Hope this helps
Chris
Test Engineer
Red Gate
Thanks