batch file - monitor http log using logparser -
i have situation have monitor execution time of webservices using logparer cannot run perfmon. becoz of unreasonable demands of client.
i have query documneted want replace u_ex110713.log dynamic file name want monitor latest file. how make happen. open using dos batch file can schedule , pipe results batch alert if threshold increases 30 seconds.
select to_string(to_localtime(to_timestamp(date, time)), 'yyyy-mm-dd hh:mm') timestamps, count(timestamps),avg(div(time-taken,1000)),max(div(time-taken,1000)),min(div(time-taken,1000)) \\server.qc.cgo.ca\c$\inetpub\logs\logfiles\w3svc1\u_ex110713.log group timestamps order timestamps asc
honestly, if in place i'd end querying *ex*.log
in directory, knowing processes in place zip , delete logs on monthly basis.
you current system time , use create statement, i'm afraid knowledge isn't great, i'm not aware of way pull system time in utc (which, assuming you're using iis defaults, need file rollover).
that said, i'm not sure using logs trigger timing results best bet. shouldn't built system itself?
Comments
Post a Comment