LOGPARSER #18: Top 10 pages with most hits

  • Article

Will give you your top pages with most hits and some additional data. If your top 10 pages with most hits are the same as your top slow pages and/or largest you might want to do something about it.

Select
TOP 10
STRCAT(EXTRACT_PATH(cs-uri-stem),'/') AS RequestPath,
EXTRACT_FILENAME(cs-uri-stem) AS RequestedFile,
COUNT(*) AS TotalHits,
Max(time-taken) AS MaxTime,
AVG(time-taken) AS AvgTime,
AVG(sc-bytes) AS AvgBytesSent
INTO
Top10Urls.txt
FROM
logs\iis\ex*.log
GROUP BY
cs-uri-stem
ORDER BY
TotalHits
DESC

//Anders