LOGPARSER #4: Top 10 largest ASPX pages

  • Article

Script for checking your largest pages. Maybe you can reduce the size of these pages? Good to know before a performance test etc

Select
Top 10
StrCat(Extract_Path(TO_Lowercase(cs-uri-stem)),'/') AS RequestedPath,
Extract_filename(To_Lowercase(cs-uri-stem)) As RequestedFile,
Count(*) AS Hits,
Max(time-taken) As MaxTime,
Avg(time-taken) As AvgTime,
Max(sc-bytes) As BytesSent
INTO top10pagesbysize.txt
FROM
logs\iis\ex*.log
WHERE
(Extract_Extension(To_Lowercase(cs-uri-stem)) IN ('aspx'))
AND (sc-status = 200)
GROUP BY
To_Lowercase(cs-uri-stem)
ORDER BY
BytesSent,
Hits,
MaxTime
DESC

//Anders