I uploaded some LogParser SQL Statements for IIS Log files.
- http://www.ronischuetz.com/code/AverageResponseTimePerHour.html
- http://www.ronischuetz.com/code/Hit_Frequency.html
- http://www.ronischuetz.com/code/NetworkAnalysis.html
- http://www.ronischuetz.com/code/RequestsPerHour.html
- http://www.ronischuetz.com/code/RequestsPerMin.html
- http://www.ronischuetz.com/code/RequestsPerMin_WebSites.html
- http://www.ronischuetz.com/code/ResponseTime.html
- http://www.ronischuetz.com/code/Top50LongestRequest.html
- http://www.ronischuetz.com/code/unique_clients.html
- http://www.ronischuetz.com/code/uniqueClientsPerHour1.html
- http://www.ronischuetz.com/code/uniqueClientsPerHour2.html
with a simple batch job you able to execute all queries at once:
Download: http://www.ronischuetz.com/code/LogParserSqlScripts.zip
No comments:
Post a Comment