How can we help you today? How can we help you today?

sql monitor alert level not changing down a level

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
stevenhoban
0

Comments

3 comments

Sort by
  • priyasinha
    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
    priyasinha
    0
  • stevenhoban
    ive got all the screen shots exce[t the 'frgmented indexe' tab - there isnt one !
    stevenhoban
    0
  • priyasinha
    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
    priyasinha
    0

Add comment

Please sign in to leave a comment.