Skip to Content.
Sympa Menu

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

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: michael.peppler AT bnpparibas.com
  • To: Matthias.Apitz AT Sisis.de, freetds AT lists.ibiblio.org
  • Subject: Re: [freetds] FreeTDS && Sybase's ESQL/C
  • Date: Thu, 20 Apr 2006 10:37:26 +0200

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.





Archive powered by MHonArc 2.6.24.

Top of Page