sql monitor alert level not changing down a level
stevenhoban
Posts: 21
I have the alert "Increased % of fragmented indexes" set up on sql monitor. The medium level alert is set when the value reaches 25 and the alert was fired at value 29. I last night ran some index maintenance jobs to rebuild if over 30% fragmentation and reorganise if over 5%.
The alert collects the data once a day @ 13:35 and i can see the alert has now been 'downgraded' from medium to Low when i click on the 'alert history'
How is it then, that the actual alert on the inbox is still showing as 'Medium' - should this not have changed to a blue 'low'.?
Also if i set to re-organise my indexes with 5% or above fragmentation level, howcome this is still showing as a downgraded leve. Shouldnt it be set to 'ended'
Thanks
Steven
The alert collects the data once a day @ 13:35 and i can see the alert has now been 'downgraded' from medium to Low when i click on the 'alert history'
How is it then, that the actual alert on the inbox is still showing as 'Medium' - should this not have changed to a blue 'low'.?
Also if i set to re-organise my indexes with 5% or above fragmentation level, howcome this is still showing as a downgraded leve. Shouldnt it be set to 'ended'
Thanks
Steven
Comments
Could you please email screen shot of the following at priya.sinha@red-gate.com:
- Details tab for the alert.
- Fragmented indexes tab for the alert.
- Alert history tab for the alert.
- Click on 'configure alert' link on the alert details page and then send screen shot of the Alert settings page.
Thanks,
Priya
Project Manager
Red Gate Software
Thanks,
Priya
Project Manager
Red Gate Software