Log Parser Plus example query

Requests by seconds to process, with percentages

Number of requests that took how x seconds to process, rounded up to the nearest second, with what percent of requests that is.
  • iisw3c
logparser -rtp:-1 -i:iisw3c "SELECT ADD(DIV(QUANTIZE(time-taken,1000),1000),1) AS [Seconds], COUNT(*) AS [Requests], MUL(PROPCOUNT(*),100) AS [Percent] INTO RequestTimes.txt FROM ex1003*.log GROUP BY [Seconds] ORDER BY [Seconds]"
Leave a comment on this query.

View more examples.

blog comments powered by Disqus