Trust me; this tool is 1000 times better: RRR|Log from http://www.rrr.se/en/
arwklga does not do logfiles correct, all the 7.x logfiles I have tried does not produce any output. (it creates an error on all sql log entries) Regards, Jarl On 10/24/07, LJ LongWing (Head) <[EMAIL PROTECTED]> wrote: > I also only have 2.11, which is a little over 2 years old and can't find > anything newer on bmcdn > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Hall Chad - chahal > Sent: Wednesday, October 24, 2007 10:01 AM > To: [email protected] > Subject: Re: Termination of SQL-calls in logfiles > > Jarl, > A bit off topic but... > > Out of curiosity, where did you get arwklga 2.15? I got 2.12 from someone at > support last year. The last time I tried to download it from the BMCDN it > was 2.11. Are there any new features in 2.15? > > Thanks, > > Chad Hall > (501) 342-2650 > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Jarl Grøneng > Sent: Wednesday, October 24, 2007 10:41 AM > To: [email protected] > Subject: Re: Termination of SQL-calls in logfiles > > Not sure if this helps... > > > From AR System Log Analyzer (arwklga) User Guide version 2.15: > > Q. Some of the longest running SQL statements are reported as running longer > than the enclosing API call or for a length of time that is just absurd. > Why? > > A. As of AR System 5.1, the COMMIT TRANSACTION statements were no longer > issued to finalize most transactions in MS SQL Server and Sybase SQL Server. > This was done in order to speed processing. > Unfortunately, this left the Log Analyzer with no way to determine the time > at which the results of the SQL statement were returned to the AR System. No > convenient workaround has been established except to drill down into the log > to make a best logical determination as to which timings are realistic and > which are not. > > > -- > Jarl > > On 10/24/07, Misi Mladoniczky <[EMAIL PROTECTED]> wrote: > > Hi All, > > > > In some databases, it is hard to find the start and end of each set of > > SQL-calls. A commit/rollback is there in some databases. > > > > I recall that some kind of option was introduced in 7.0, so that the a > > logrow was added after each set of SQL-calls. > > > > I have been unsuccessful in finding this setting in the documentation... > > > > Could someone please point me in the right direction? > > > > 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. > > * RRR|Translator - Manage and automate your language translations. > > Find these products, and many free tools and utilities, at http://rrr.se. > > > > ______________________________________________________________________ > > _________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > > ARSlist:"Where the Answers Are" > > > > ____________________________________________________________________________ > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the > Answers Are" > *************************************************************************** > The information contained in this communication is confidential, is intended > only for the use of the recipient named above, and may be legally > privileged. > > If the reader of this message is not the intended recipient, you are hereby > notified that any dissemination, distribution or copying of this > communication is strictly prohibited. > > If you have received this communication in error, please resend this > communication to the sender and delete the original message or any copy of > it from your computer system. > > Thank You. > **************************************************************************** > > ____________________________________________________________________________ > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the > Answers Are" > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the > Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
