IIS 访问统计百分比

SELECT TO_LOWERCASE (EXTRACT_SUFFIX(REPLACE_STR( cs-uri-stem,'/gzip',''),0,'/')) AS [方法名称]
, AVG(time-taken) AS [平均执行时间(ms)]
, MAX(time-taken) AS [最长执行时间(ms)]
, MIN(time-taken) AS [最短执行时间(ms)]
, SUM(time-taken) AS [总执行时间(ms)]
, COUNT(*) AS [单台服务器每天执行次数]
, MUL(PROPCOUNT(*), 100.0) AS [执行次数占比(%)]
FROM '[LOGFILEPATH]' WHERE sc-status=200
GROUP BY [方法名称]
ORDER BY [单台服务器每天执行次数] DESC , [平均执行时间(ms)] DESC