« Previous Next »

Thread: can't get DumpTraceReqs.js to work !

Last post 04-27-2006 8:51 AM by LogParser User : Delux. 5 replies.

Average Rating Rate It (5)

RSS

Page 1 of 1 (6 items)

Sort Posts:

  • 04-24-2005, 12:45 AM

    can't get DumpTraceReqs.js to work !

    Hi

    I'm trying to get the sample script DumpTraceReqs.js to work..

    i'm running it om an binary Event Trace log file (.etl) from an IIS ASP tracing session

    it fails with

    line: 70
    char: 2
    error: cannot find field "requestURL" in recordset [the parameter is incorrect]

    anyone have a clue.. i hoped it would work out of the box

    cheers

    Brian

     

     

     

     

  • 04-25-2005, 7:37 AM In reply to

    RE: can't get DumpTraceReqs.js to work !

    What OS is this? If it's WS03 RTM, you should use DumpTraceReqs_RTM.js; DumpTraceReqs.js is for SP1 only.

    Also, if you're using DumpTraceReqs.js (SP1), the session needs to include the "IIS: WWW Server" provider events. That's where the 'requestURL' field comes from.

  • 04-26-2005, 2:00 AM In reply to

    RE: can't get DumpTraceReqs.js to work !

    hi Gabriele.

    I'm using w2k3 Sp1 and you'r correct i where missing the IIS: WWW Server provider..

    i just saw the url in the user data so I did't notice

    What i would like to archieve is to find the asp "urls" with the most CPU usage and Slowest URLs as well.
    (i guess that i only need the asp provider for that)

    Would that be possible with logparser?..

    thanks a lot.

    cheers

    Brian

  • 04-26-2005, 8:05 AM In reply to

    RE: can't get DumpTraceReqs.js to work !

    Yep, that's possible, but you'll need to write a few lines of JScript for it. The basic idea is that you need to do delta's among records - the time spent by a page is the difference between the timestamp in the END event and the timestamp in the START event. Log Parser doesn't natively support calculating differences between values in different records (so does SQL, but SQL supports inner JOINS, while Log Parser doesn't support JOIN yet).

    There's a "FindSlowFilters.js" sample script in the samples folder that does just this with ISAPI filters: parses a WS03 RTM trace, calculates the delta's between the end-start events of each filter call, and finds out which filters are slow. You should be able to adapt it to ASP pages with minimal effort.

  • 04-27-2006, 8:51 AM In reply to

    RE: can't get DumpTraceReqs.js to work !

    Hello,

    I'm trying to extract some readable information - most importantly timestamps; I can't interpret those given by tracerpt - from a .etl file (which logs process creation/deletion) , but it fails with this error:

    Line: 35
    Char: 1
    Error: Error parsing query: SELECT clause: Syntax Error: unknown field 'ContextID'.

    I'm not much into jscript, just wanted to find a tool that works without messing with it too much
    Please give me some advice how to get it done...

    Thanks
  • 05-03-2006, 10:29 AM In reply to

    RE: can't get DumpTraceReqs.js to work !

    Try the following:

    C:\>LogParser.exe "SELECT * FROM myfile.etl"

    and post a snippet of the output.

Page 1 of 1 (6 items)
Microsoft Communities