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

Popular posts from this blog

linux - Using a Cron Job to check if my mod_wsgi / apache server is running and restart -

actionscript 3 - TweenLite does not work with object -

jQuery Ajax Render Fragments OR Whole Page -