Hi John,
Well, the TID is the thread id. It seems to be a number that is assigned
to each thread as it starts up. Sometimes you can see ids with number over
1000, but in the same log there will only be a limited number of threads,
as defined in the configuration of the server. Maybe threads die and a new
is spawned... It can sometimes be relevant to group things per thread, to
see what the specific thread has been doing before it dies or something
like that.
The RPC ID groups a uniqe API-call to the server in question.
The Client-RPC is the RPC-port used by the client to connect. In the early
days, the client connected to various ports, but nowadays it connects to a
central port if it does is not configured to go somewhere else, such as to
a private server.
Best Regards - Misi, RRR AB, http://www.rrr.se
Products from RRR Scandinavia:
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
Find these products, and many free tools and utilities, at http://rrr.se.
>
> looking at a sql log from ars 6.3 -- how do you interpret ???
>
>
> What is TID and RPC ID and Client-RPC.
>
>
> I can guess at most - but thought I would get opinions.
>
> Ultimately - the goal is to find the start and end times of a select or
> insert etc...
>
> Is that even possible with a 6.3 log?
>
> 7.5 logs have OK statements - which relate back to the RPC ID -- and then
> you can do simple subtraction to figure out the diff time.
>
>
>
>
> <SQL > <TID: 0000000007> <RPC ID: 0001002730> <Queue: Fast >
> <Client-RPC: 390620 >
> <SQL > <TID: 0000000007> <RPC ID: 0001002730> <Queue: Fast >
> <Client-RPC: 390620 >
> <SQL > <TID: 0000000007> <RPC ID: 0001002730> <Queue: Fast >
> <Client-RPC: 390620 >
> <SQL > <TID: 0000000009> <RPC ID: 0001002731> <Queue: Fast >
> <Client-RPC: 390620 >
>
>
>
>
> --
> John Sundberg
>
> Kinetic Data, Inc.
> "Building a Better Service Experience"
> Recipient of the WWRUG09 Innovator of the Year Award
>
> [email protected]
> 651.556.0930 I www.kineticdata.com
>
>
>
>
>
>
>
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
>
> --
> This message was scanned by ESVA and is believed to be clean.
>
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
