FreeTDS Development Group

[michael.peppler AT bnpparibas.com]

I see.

The next step might be to enable Sybase auditing, which can be made to log
all SQL statements to the sybsecurity database.

Michael




Internet
guru AT Sisis.de@lists.ibiblio.org - 20/04/2006 10:24


Please respond to Matthias.Apitz AT Sisis.de; Please respond to
       freetds AT lists.ibiblio.org

Sent by:    freetds-bounces AT lists.ibiblio.org

To:    freetds

cc:


Subject:    Re: [freetds] FreeTDS && Sybase's ESQL/C


El día Thursday, April 20, 2006 a las 09:52:05AM +0200,
michael.peppler AT bnpparibas.com escribió:

> Hi,
>
> Replacing the Sybase libs with freetds might work, although the two
aren't
> fully binary compatible yet (AFAIK).
>
> Have you considered using Ribo to capture the TDS traffic, and/or using
the
> MDA tables on the server to see which statements are taking too long?
>
> Michael

Hi,

Yes, we considered and tested both. The problem with the MDA tables
seems to be that enabling the capturing into the MDA and punching them
away from time to time (because if not, they get written around) to some
place is expansive for the performance and after all it turned out
that in the moment of the performance dropout the ASE had no time to
update correctly the MDA tables. We spent a lot of time in that w/o
getting good results.

Ribo in turn does not produce good output, especially if you are watching
some 50-100 connections at the same time.

Why we can't have just old-syslog-style messages into one file with
lines like:

12:20:20:470 spid EXEC SQL PREPARE sid_titel_worte  FROM :select_anw
12:20:20:470 spid SELECT SYB_IDENTITY_COL,* from titel_worte (index
titel_fldesk)
  WHERE feldnr  = ? AND desk  = ? FOR READ ONLY at isolation read
uncommitted
12:20:23:600 spid EXEC SQL CLOSE titel_worte_seq

Then you just go to the file to exactly the moment in time and
have a look which statements have been issued by all spid's just
before.

With FreeTDS my idea was just enhancing a bit the logging which is
already there in the sources.

 matthias

--
Matthias Apitz / Sisis Informationssysteme GmbH
ein Tochterunternehmen der OCLC PICA B.V. Leiden (NL)
D-82041 Oberhaching, Gruenwalder Weg 28g
Fon: +49 89 / 61308-351, Fax: -399, Mobile +49 170 4527211
http://www.sisis.de/~guru/
_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
 http://lists.ibiblio.org/mailman/listinfo/freetds



This message and any attachments (the "message") is
intended solely for the addressees and is confidential. 
If you receive this message in error, please delete it and 
immediately notify the sender. Any use not in accord with 
its purpose, any dissemination or disclosure, either whole 
or partial, is prohibited except formal approval. The internet
can not guarantee the integrity of this message. 
BNP PARIBAS (and its subsidiaries) shall (will) not 
therefore be liable for the message if modified. 

                ---------------------------------------------

Ce message et toutes les pieces jointes (ci-apres le 
"message") sont etablis a l'intention exclusive de ses 
destinataires et sont confidentiels. Si vous recevez ce 
message par erreur, merci de le detruire et d'en avertir 
immediatement l'expediteur. Toute utilisation de ce 
message non conforme a sa destination, toute diffusion 
ou toute publication, totale ou partielle, est interdite, sauf 
autorisation expresse. L'internet ne permettant pas 
d'assurer l'integrite de ce message, BNP PARIBAS (et ses
filiales) decline(nt) toute responsabilite au titre de ce 
message, dans l'hypothese ou il aurait ete modifie.