SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Red Gate Sql Monitor Alert is downgraded but still shows as HIGH


Red Gate Sql Monitor Alert is downgraded but still shows as HIGH

Author
Message
PearlJammer1
PearlJammer1
SSCarpal Tunnel
SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)

Group: General Forum Members
Points: 4472 Visits: 1468
Hi

I have been reorganising/rebuilding some indexes due to high fragmentation due to an alert generated by Red Gates sqlmonitor.
I have ran some scripts and done the required steps to get the indexes back in shape.
The alert moves to the top of the pile and when i hover my mouse over the 'status' it says 'downgraded' with the time - however i still have the red alert box which says 'high' - this shoud now read 'low' or the alert should maybe be totally cleared if my index rebuild truly did its job !
How can i get the red alert box to change to what it should reflect after the downgraded process ?

Thanks
Shabba
Shabba
SSCrazy
SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)

Group: General Forum Members
Points: 2781 Visits: 1846
Just a thought Pearl but wouldn't you be better posting this on the Redgate Support forums or perhaps giving them a call directly?

Their support really is very good.
priya.sinha
priya.sinha
Old Hand
Old Hand (327 reputation)Old Hand (327 reputation)Old Hand (327 reputation)Old Hand (327 reputation)Old Hand (327 reputation)Old Hand (327 reputation)Old Hand (327 reputation)Old Hand (327 reputation)

Group: General Forum Members
Points: 327 Visits: 74
Hi,

Fragmentation check is very expensive on Monitored entity hence SQL Monitor checks for this only once a week at 1:00 am on Sunday (Base monitor local time). So even if you have re-build index and the alert condition no longer exists, the alert is still 'Active' because the next check will only happen on Sunday. After the collection happens on Sunday, the alert will be updated.

Hope this explains. Let us know if you are any more question.

Thanks,
Priya Sinha
Project Manager, SQL Monitor.
PearlJammer1
PearlJammer1
SSCarpal Tunnel
SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)

Group: General Forum Members
Points: 4472 Visits: 1468
Once a week you say ?
Mine is set to once a day. Daily is the longest time interval i can set - there is no option for a weekly collection, unless we are talking about different things maybe ?
priya.sinha
priya.sinha
Old Hand
Old Hand (327 reputation)Old Hand (327 reputation)Old Hand (327 reputation)Old Hand (327 reputation)Old Hand (327 reputation)Old Hand (327 reputation)Old Hand (327 reputation)Old Hand (327 reputation)

Group: General Forum Members
Points: 327 Visits: 74
Hi,

Yes, looks like we are talking about different things. Are you referring to built-in 'Fragmented indexes' alert?

Thanks,
Priya
PearlJammer1
PearlJammer1
SSCarpal Tunnel
SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)

Group: General Forum Members
Points: 4472 Visits: 1468
Yes the alert is the 'Increased % of fragmented indexes' - even so though, i changed the metric to be collected every 5 mins to intially see if it would change after index rebuild - and it didnt. I think i know why though. I have learned that sometimes after you run a defrag, if the indexes pages are small and over multiple extents then they remain fragmented. Is this correct ?
Even so though i still dont get why the alert showed as downgraded ( so it recognised my good work at defragging the indexes Smile ) but never changed from a red 'high' to a blue 'low' alert.
priya.sinha
priya.sinha
Old Hand
Old Hand (327 reputation)Old Hand (327 reputation)Old Hand (327 reputation)Old Hand (327 reputation)Old Hand (327 reputation)Old Hand (327 reputation)Old Hand (327 reputation)Old Hand (327 reputation)

Group: General Forum Members
Points: 327 Visits: 74
Hi,

Ah ha. That explains. You are talking about this custom alert 'http://sqlmonitormetrics.red-gate.com/percentage-of-fragmented-indexes/' whereas I was talking about 'Fragmented indexes' alert.

Could you please email me screen shots of the following to priya.sinha@red-gate.com:

- Custom alert showing settings for High, Medium and Low value.
- Screen shot from Analysis page for this custom metric showing last 2,3 hours.
- Screen shot of the alert showing 'Details' page.
- Screen shot of the alert showing 'Alert history' page.

Thanks,
Priya
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum








































































































































































SQLServerCentral


Search