Average response time by half hour

Log Parser Plus example query

Average response time by half hour

Returns the average response time, in milliseconds, of a particular page (in this case .as* files) broken into 30 minute blocks.

Keywords:

iisw3c

Statement:

logparser -i:iis "SELECT TO_LOCALTIME(QUANTIZE(time, 1800)) as HalfHour, AVG(time-taken) as Time INTO AvgResponse.txt FROM *ex1107*.log WHERE cs-uri-stem like '%.as%' AND sc-status < 400 GROUP BY HalfHour ORDER BY HalfHour ASC"

Notes: Query written and provided by Chevis L. Nelson (drcheeves [at] yahoo.com). Leave a comment on this query.

View more examples.