Average executing time for ASP.NET pages

Courtesy of “A Developer Strayings” blog:

logparser “SELECT AVG(time-taken) As AverageTimeTaken, MAX(time-taken) As MaxTimeTaken, COUNT(*) As Hits, TO_LOWERCASE(cs-uri-stem) INTO %1 FROM *.log WHERE EXTRACT_EXTENSION(TO_LOWERCASE(cs-uri-stem)) = ‘%2’ GROUP BY cs-uri-stem ORDER BY AverageTimeTaken DESC” -i:IISW3C -RTP:-1

The output will look like this:

Statistics:
———–
Elements processed: 309751
Elements output: 0
Execution time: 1.45 seconds