Response Time alert when any devices goes over the average by 10% or 20%

Question

Hi,

Does anyone have an alert or can help with creating an alert for any routers going over 10% of the lets say the last 7 days Response Time average? I really don't want to create one alert for each routers.

Thank you

mharvey · Answer

You just have to make sure that you have the Device_Type custom property configured in your environment, otherwise the alert won't trigger for you.  There is a bit of a flaw in the logic as the query is looking for any node that has an average that is 10% greater than and average of it's average of that week.  There's going to be some issues in how that calculation works.

gcarreira · Answer

Actually I found a custom alert that will do it.

Here it is if anyone wants it.

You need to create a Custom SQL Alert

Then add the text below:

JOIN ResponseTime ON Nodes.NodeID=ResponseTime.NodeID

WHERE ResponseTime.DateTime BETWEEN DATEADD(Day, -7, getdate()) AND Getdate()

AND Nodes.Device_Type LIKE 'Router'

Group By Nodes.NodeID, Nodes.Caption, Nodes.AvgResponseTime

Having Nodes.AvgResponseTime > 1.10*(AVG(ResponseTime.AvgResponseTime))

mharvey · Answer

Not sure what you're asking for here.  Are you wanting to report on Response Time or packet loss?  Response time is in ms, so there's not really a way to say response time goes over 10% without setting a baseline of what would be "acceptable" response time.