Will give you your top pages with most hits and some additional data. If your top 10 pages with most hits are the same as your top slow pages and/or largest you might want to do something about it.

Select
   TOP 10
   STRCAT(EXTRACT_PATH(cs-uri-stem),'/') AS RequestPath,
   EXTRACT_FILENAME(cs-uri-stem) AS RequestedFile,
   COUNT(*) AS TotalHits,
   Max(time-taken) AS MaxTime,
   AVG(time-taken) AS AvgTime,
   AVG(sc-bytes) AS AvgBytesSent
INTO
  Top10Urls.txt
FROM
  logs\iis\ex*.log
GROUP BY
  cs-uri-stem
ORDER BY
  TotalHits
DESC

//Anders