Log Parser 日志剖析工具下载地址(英文和日文):
http://download.csdn.net/detail/kk185800961/8459963
LogParser 查询方法:

编写sql脚本保存为: SlowPage.sql
SelectTop 20
LogRow as [Line Number],
dateas [Date],
timeas [Time],
c-ip as [Client-IP],
s-ip as [Server IP],
s-port as [Server Port],
cs-method as [Request Verb],
cs-uri-stem as [Request URI],
sc-bytes as [Bytes sent],
sc-status as [Status],
sc-substatus as [Sub-status],
sc-win32-status as [Win 32 Status],
time-taken as [Time Taken]
From
C:\inetpub\logs\LogFiles\W3SVC2\u_ex.log
Orderbytime-taken desc
打开 LogParser 命令行工具,实行脚本:
LOGPARSER -i:IISW3C file:C:\inetpub\SlowPage.sql -o:DataGrid -q:off
Log Parser Lizard 查询方法:
打开 Log Parser Lizard 可视化界面,如下图,将sql命令复制到 查询[query] 窗口中,在点击天生[generate]。
还可以以各种图形的办法显示出来,更方便、直不雅观 理解剖析情形:
在Log Parser 2.2 安装路径下,有很多自带的sql语句:
若不清楚列名称,可以先全部查询所有列,再选择有用的列进行剖析
更多的利用方法,可以参考帮助文档,有很多例子: