sql monitor alert level not changing down a level

SQL Server performance monitoring and alerting

Moderators: eddie davis, priyasinha, Adam, chriskelly, Chris Lambrou, Chris Spencer

sql monitor alert level not changing down a level

Postby stevenhoban » Fri May 24, 2013 2:01 pm

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
 
Posts: 15
Joined: Thu Apr 18, 2013 4:41 pm

Postby priyasinha » Fri May 24, 2013 2:28 pm

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
 
Posts: 532
Joined: Wed Jan 03, 2007 5:02 pm

Postby stevenhoban » Fri May 24, 2013 2:45 pm

ive got all the screen shots exce[t the 'frgmented indexe' tab - there isnt one !
stevenhoban
 
Posts: 15
Joined: Thu Apr 18, 2013 4:41 pm

Postby priyasinha » Fri May 24, 2013 3:44 pm

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
 
Posts: 532
Joined: Wed Jan 03, 2007 5:02 pm


Return to SQL Monitor 3

Who is online

Users browsing this forum: No registered users and 0 guests