LOGPARSER #5: Top 10 slowest ASPX pages

  • Article

Top 10 pages with the longest time-taken

SELECT TOP 10
cs-uri-stem,
max(time-taken) as MaxTime,
avg(time-taken) as AvgTime
INTO
toptimetaken.txt
FROM
logs\iis\ex*.log
WHERE
extract_extension(to_lowercase(cs-uri-stem)) = 'aspx'
GROUP BY
cs-uri-stem
ORDER BY
MaxTime
DESC

Top 10 pages with the longest time-taken a specific day. Great if you have customers complaining about site performance.

SELECT TOP 10
cs-uri-stem,
max(time-taken) as MaxTime,
avg(time-taken) as AvgTime
INTO
toptimetaken.txt
FROM
logs\iis\ex*.log
WHERE
extract_extension(to_lowercase(cs-uri-stem)) = 'aspx' AND TO_STRING(To_timestamp(date, time), 'MMdd')='1003'
GROUP BY
cs-uri-stem
ORDER BY
MaxTime
DESC

//Anders