LOGPARSER #5: Top 10 slowest ASPX pages


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

Comments (1)

Comments are closed.

Skip to main content