Red Gate forums :: View topic - sql monitor alert level not changing down a level
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Monitor 3
SQL Monitor 3 forum

sql monitor alert level not changing down a level

Search in SQL Monitor 3 forum
Post new topic   Reply to topic
Jump to:  
Author Message
stevenhoban



Joined: 18 Apr 2013
Posts: 15

PostPosted: Fri May 24, 2013 2:01 pm    Post subject: sql monitor alert level not changing down a level Reply with quote

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
Back to top
View user's profile Send private message
priyasinha



Joined: 03 Jan 2007
Posts: 530

PostPosted: Fri May 24, 2013 2:28 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
stevenhoban



Joined: 18 Apr 2013
Posts: 15

PostPosted: Fri May 24, 2013 2:45 pm    Post subject: Reply with quote

ive got all the screen shots exce[t the 'frgmented indexe' tab - there isnt one !
Back to top
View user's profile Send private message
priyasinha



Joined: 03 Jan 2007
Posts: 530

PostPosted: Fri May 24, 2013 3:44 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group