Options

sql monitor alert level not changing down a level

stevenhobanstevenhoban Posts: 21
edited May 24, 2013 10:44AM in SQL Monitor Previous Versions
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

Comments

  • Options
    Hi Steven,

    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
    Priya Sinha
    Project Manager
    Red Gate Software
  • Options
    ive got all the screen shots exce[t the 'frgmented indexe' tab - there isnt one !
  • Options
    My mistake Steven. I assumed that you are talking about built-in Fragmented indexes alert. I have received your email. Replying you in few minutes.

    Thanks,
    Priya
    Priya Sinha
    Project Manager
    Red Gate Software
Sign In or Register to comment.