Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Trace SQL statements

4 posts in Windows NT Last posting was on 2000-04-16 11:48:06.0Z
Pasi Moisander Posted on 2000-04-10 13:21:03.0Z
Message-ID: <38F1D53F.9C74D473@carmenta.se>
Date: Mon, 10 Apr 2000 15:21:03 +0200
From: Pasi Moisander <pasi.moisander@carmenta.se>
X-Mailer: Mozilla 4.61 [en] (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Trace SQL statements
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 33
NNTP-Posting-Host: as400.carmenta.se 193.15.207.68
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2343
Article PK: 1089772

Hi all,

Does anyone know of an application that traces the SQL statements
executed
on a Sybase SQL Server ?

Sofar I've tested Sybase SQL Monitor, ODBC trace and BDE SQL Monitor
(Included in Borland Delphi 4) with the following results:

Sybase SQL Monitor is only able to sample SQL statements with a
smallest sample interval of 1 second. Any statements executed
between the samples are lost.

ODBC trace works, but I really want to use the native driver.

BDE SQL Monitor works fine with connections from interactive
applications, but doesn't trace connections from registered
components. The trace output is very nice.

I'm using:
NT4 sp5
Sybase 11.9.2

Regards,

Pasi

--
''~``
( o o )
+---------------.oooO--(_)--Oooo.----------------------------+

| Pasi Moisander | E-Mail: Pasi.Moisander@carmenta.se |
| Carmenta AB | Voice :+46-(31)7755721 |
| Box 31121 | Fax :+46-(31)246379 |
| 40032 Göteborg .oooO | |
| SWEDEN ( ) | Oooo. |

+------------------\ (----( )------------------------------+
\_) ) /
(_/


Randy Reiter Posted on 2000-04-16 11:48:06.0Z
Reply-To: "Randy Reiter" <rreiter@sqlpower.com>
From: "Randy Reiter" <rreiter@sqlpower.com>
References: <38F1D53F.9C74D473@carmenta.se>
Subject: Re: Trace SQL statements
Date: Sun, 16 Apr 2000 07:48:06 -0400
Lines: 57
Organization: Sql Power Tools
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
Message-ID: <9dpMXs5p$GA.204@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: 209.138.245.95
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2313
Article PK: 1089743

Refer to www.sqlpower.com. The Zero Impact Sql Monitor will capture all SQL
text and performance with no impact upon the database server, network and
end-users. Scales to thousands of users. Installation is a few minutes.

The Zero Impact Top N Sql Analyzer will identify the SQL statements that run
most frequently with associated end-user service levels by SQL statement.

Randy Reiter

Sql Power Tools
702.990.3209
www.sqlpower.com

Pasi Moisander <pasi.moisander@carmenta.se> wrote in message
news:38F1D53F.9C74D473@carmenta.se...
> Hi all,
>
> Does anyone know of an application that traces the SQL statements
> executed
> on a Sybase SQL Server ?
>
> Sofar I've tested Sybase SQL Monitor, ODBC trace and BDE SQL Monitor
> (Included in Borland Delphi 4) with the following results:
>
> Sybase SQL Monitor is only able to sample SQL statements with a
> smallest sample interval of 1 second. Any statements executed
> between the samples are lost.
>
> ODBC trace works, but I really want to use the native driver.
>
> BDE SQL Monitor works fine with connections from interactive
> applications, but doesn't trace connections from registered
> components. The trace output is very nice.
>
> I'm using:
> NT4 sp5
> Sybase 11.9.2
>
> Regards,
>
> Pasi
>
> --
> ''~``
> ( o o )
> +---------------.oooO--(_)--Oooo.----------------------------+
> | Pasi Moisander | E-Mail: Pasi.Moisander@carmenta.se |
> | Carmenta AB | Voice :+46-(31)7755721 |
> | Box 31121 | Fax :+46-(31)246379 |
> | 40032 Göteborg .oooO | |
> | SWEDEN ( ) | Oooo. |
> +------------------\ (----( )------------------------------+
> \_) ) /
> (_/


Brad McLeod Posted on 2000-04-11 20:17:44.0Z
From: "Brad McLeod" <brad.mcleod@worldnet.att.net>
References: <38F1D53F.9C74D473@carmenta.se>
Subject: Re: Trace SQL statements
Date: Tue, 11 Apr 2000 15:17:44 -0500
Lines: 51
X-Newsreader: Microsoft Outlook Express 4.72.3155.0
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3155.0
Message-ID: <a6o2xO$o$GA.201@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: ailsa-ded.webzone.net 208.152.102.253
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2332
Article PK: 1089763

Pasi -

Check this site out: http://www.speditor.com/default.asp?0330

We used several of their utilities and are quite pleased.

Brad McLeod
StoneHenge Partners, Inc.

Pasi Moisander wrote in message <38F1D53F.9C74D473@carmenta.se>...
>Hi all,
>
>Does anyone know of an application that traces the SQL statements
>executed
>on a Sybase SQL Server ?
>
>Sofar I've tested Sybase SQL Monitor, ODBC trace and BDE SQL Monitor
>(Included in Borland Delphi 4) with the following results:
>
>Sybase SQL Monitor is only able to sample SQL statements with a
>smallest sample interval of 1 second. Any statements executed
>between the samples are lost.
>
>ODBC trace works, but I really want to use the native driver.
>
>BDE SQL Monitor works fine with connections from interactive
>applications, but doesn't trace connections from registered
>components. The trace output is very nice.
>
>I'm using:
> NT4 sp5
> Sybase 11.9.2
>
>Regards,
>
>Pasi
>
>--
> ''~``
> ( o o )
>+---------------.oooO--(_)--Oooo.----------------------------+
>| Pasi Moisander | E-Mail: Pasi.Moisander@carmenta.se |
>| Carmenta AB | Voice :+46-(31)7755721 |
>| Box 31121 | Fax :+46-(31)246379 |
>| 40032 Göteborg .oooO | |
>| SWEDEN ( ) | Oooo. |
>+------------------\ (----( )------------------------------+
> \_) ) /
> (_/


Pasi Moisander Posted on 2000-04-16 09:08:30.0Z
Message-ID: <38F9830E.6A5502F4@carmenta.se>
Date: Sun, 16 Apr 2000 11:08:30 +0200
From: Pasi Moisander <pasi.moisander@carmenta.se>
X-Mailer: Mozilla 4.61 [en] (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Trace SQL statements
References: <38F1D53F.9C74D473@carmenta.se> <a6o2xO$o$GA.201@forums.sybase.com>
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 71
NNTP-Posting-Host: as400.carmenta.se 193.15.207.68
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2315
Article PK: 1089744

Brad,

Once I got the Sybase auditing feature working according to the tip
from Bret Halford below it gave me the info I needed.

Bret Halford:
<<<

Have you looked at the Auditing feature within ASE itself, particularly
auditing "cmdtext" for
all users? The only area where I recall where this presents problems
is with embedded-sql clients,
where sargs are passed as variables.

-bret
>>>

Thank you for your tip, I will try out SpEd ASAP. A good thing about
SpEd
is that it supports several database servers.

/Pasi

Brad McLeod wrote:
>
> Pasi -
>
> Check this site out: http://www.speditor.com/default.asp?0330
>
> We used several of their utilities and are quite pleased.
>
> Brad McLeod
> StoneHenge Partners, Inc.
>
> Pasi Moisander wrote in message <38F1D53F.9C74D473@carmenta.se>...
> >Hi all,
> >
> >Does anyone know of an application that traces the SQL statements
> >executed
> >on a Sybase SQL Server ?
> >
> >Sofar I've tested Sybase SQL Monitor, ODBC trace and BDE SQL Monitor
> >(Included in Borland Delphi 4) with the following results:
> >
> >Sybase SQL Monitor is only able to sample SQL statements with a
> >smallest sample interval of 1 second. Any statements executed
> >between the samples are lost.
> >
> >ODBC trace works, but I really want to use the native driver.
> >
> >BDE SQL Monitor works fine with connections from interactive
> >applications, but doesn't trace connections from registered
> >components. The trace output is very nice.
> >
> >I'm using:
> > NT4 sp5
> > Sybase 11.9.2
> >
> >Regards,
> >
> >Pasi
> >
> >--
> > ''~``
> > ( o o )
> >+---------------.oooO--(_)--Oooo.----------------------------+
> >| Pasi Moisander | E-Mail: Pasi.Moisander@carmenta.se |
> >| Carmenta AB | Voice :+46-(31)7755721 |
> >| Box 31121 | Fax :+46-(31)246379 |
> >| 40032 Göteborg .oooO | |
> >| SWEDEN ( ) | Oooo. |
> >+------------------\ (----( )------------------------------+
> > \_) ) /
> > (_/

--
''~``
( o o )
+---------------.oooO--(_)--Oooo.----------------------------+
| Pasi Moisander | E-Mail: Pasi.Moisander@carmenta.se |
| Carmenta AB | Voice :+46-(31)7755721 |
| Box 31121 | Fax :+46-(31)246379 |
| 40032 Göteborg .oooO | |
| SWEDEN ( ) | Oooo. |
+------------------\ (----( )------------------------------+
\_) ) /
(_/