Hi,
Not sure where I got it. The new stuff:
Release Notes
Version Date Notes
------- ------------ -----------------------------------------------
2.15 26-SEP-2006 - Allow for 'OK' SQL log entry (new to ARS 7.0)
- The following SQL log entries are now
considered valid and statistics are gathered:
CREATE
ALTER
DROP
- Fix defect where "invalid" SQL log entries do
not count as terminators for valid entries.
- Limit number of SQL exceptions.
2.12 01-DEC-2005 - Allow for two-character abbreviation of
day-of-week in timestamps.
--
Jarl
On 10/24/07, Hall Chad - chahal <[EMAIL PROTECTED]> wrote:
> 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: arslist@ARSLIST.ORG
> 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"
