Log Parser Plus example query
Requests by seconds to process
Number of requests that took how x seconds to process, rounded up to the nearest second.
Statement:Leave a comment on this query.
logparser -i:iisw3c -o:csv "SELECT ADD(DIV(QUANTIZE(time-taken, 1000), 1000), 1) AS [Seconds], COUNT(*) AS [Requests] INTO RequestProcessingTimes.csv FROM ex0906*.log GROUP BY [Seconds] ORDER BY [Seconds] DESC"
blog comments powered by Disqus