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.
Statement:Leave a comment on this query.
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]"
blog comments powered by Disqus