LOGPARSER #4: Top 10 largest ASPX pages


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

Skip to main content