LOGPARSER #18: Top 10 pages with most hits


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

Skip to main content