Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Red Gate Sql Monitor Alert is downgraded but still shows as HIGH Expand / Collapse
Author
Message
Posted Wednesday, May 15, 2013 8:38 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 8:30 AM
Points: 247, Visits: 976
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
Post #1453135
Posted Thursday, May 16, 2013 12:54 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, March 11, 2014 5:33 AM
Points: 307, Visits: 1,846
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.
Post #1453340
Posted Thursday, May 16, 2013 5:37 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, September 19, 2013 8:38 AM
Points: 17, 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.
Post #1453445
Posted Thursday, May 16, 2013 7:43 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 8:30 AM
Points: 247, Visits: 976
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 ?
Post #1453540
Posted Thursday, May 16, 2013 8:41 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, September 19, 2013 8:38 AM
Points: 17, Visits: 74
Hi,

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

Thanks,
Priya
Post #1453587
Posted Thursday, May 16, 2013 9:25 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 8:30 AM
Points: 247, Visits: 976
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 :) ) but never changed from a red 'high' to a blue 'low' alert.
Post #1453628
Posted Friday, May 17, 2013 3:29 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, September 19, 2013 8:38 AM
Points: 17, 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
Post #1453907
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse