Need to understand how metrics such as average response are calculate

nbs

I'm using the followng query;

use NetPerfMon

select

    nd.Caption as [Store name],

    nd.AssetTag as [Store number],

    nd.MachineType as [Router Model],

    nd.IP_Address as [IP Address],

    nd.Owner as [Franchisee],

    round(rst.AvgResponseTimeMean,2) as [Internet Health],

    case nd.IsServiceWrap when 0 then 'VPN' else 'MPLS' end as ConnectionType,

    case nd._3GBackup when 0 then 'No backup' else 'Cellular backup' end as [Backup Type],

    abs(round(rst.PercentLossMean,1) - 100)  as Reliability

from dbo.nodes as nd

    inner join [dbo].[ResponseTime_Statistics] as rst on nd.NodeID = rst.NodeID

Where

    rst.TimeFrameID = 3 and

    nd.SiteConnection = 1 and

    nd.owner like '%Mitchell-Hyundyne%'

Order by rst.PercentLossMean desc,nd.Owner

To get an idea re: health for our sites (ie. if average response is always high, then ... if percent is under 99.5% .. etc)

I believe that is average response and percent loss over 3 days? is there a table i can pull average response and percent loss over 7 days?

Regards

NBS

mesverrum

I believe timeframeid=3 is wrong, you should be doing something like a rst.datetime > dateadd('min',-3,getdate())

The timestamp column might have a different name on that table, but broadly speaking that is basically the syntax for filtering to the last 3 days.