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 john.sundb...@kineticdata.com 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"