Frederick,
Now I get an error "Number of query values and destination fields are not
the same"
I dont't know if it's something wrong with my logfiles...
I also tried ARLogAnalyzer as Jarl sugested, but that didn't work...
I have tried that one before, and it didn't work then either.
Was trying version 2.11, would that be the correct version??
I don't have access to the community downloads for the moment.
I don't understand why my logfiles isn't working...
// Niklas
On 11/12/06, Jarl Grøneng <[EMAIL PROTECTED]> wrote:
Download ARLogAnalyzer from Community Download. It's much, much, much
better than the Logtmr program.
Be sure to read the Frequently Asked Questions section.
The tool is just awesome... Can't tune performance without it.
--
Jarl
On 12/11/06, Niklas Asplund <[EMAIL PROTECTED]> wrote:
> Hi
> I am trying to run the arlogtmr utility on a SQL Logfile.
>
> I'm running:
> arlogtmr.exe -i h:\ars\loggar\sql.log -d 5
>
> The result I'm getting for each row is:
>
> ****** Corruptted line in log file ******
> <SQL > <TID: 0000001008> <RPC ID: 0000375667> <Queue: Fast >
> <Client-RPC: 390620 > <USER: sda1 > /* mσ dec
11
> 2006 10:27:19.2550 */SELECT T506.C1,T506.C1 FROM T506 WHERE
> ('AG005056001A1AhDiIQgN_6LEwJQEA' = T506.C179) ORDER BY 1
> ASC
>
> I'm running arlogtmr v5.1 against a logfile generated on a 6.3 ARserver.
>
> I know I've seen others with the same problem, but haven't seen any
solution
> to it.
>
> Does anyone have a small SQL logfile that actually works with arlogtmr
so I
> can compare a "Non corrupted" line with mine, so I can find the
problem??
>
> Or does anyone else have a free utility that finds long execution
times??
>
> Thanks for your help!!
>
> // Niklas Asplund
> Siemens Business Services Sweden
