Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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