Very Computer

Is there a tool to moniter all SQL commands on a Sybase database or at least
those from one user ?

 I'm having problems with a 3rd party application and want to be able to
filter out all commands sent from one user to see exactly  what's happening.
I can't get into the code or session to set traceon. Or is there a way of
setting that centrally for another user ?

We're using the Sybase interface driver not ODBC.

Coming from a Microsoft SQLServer background I'm missing a tool like SQL
Trace.

Any suggestions are much appreciated.

--
Neville Higgs
WAZ-Mediengruppe

Yes, a couple options are

1) enable auditing and audit the "cmdtext" sent by certain users

2) On ASE 11.5 or higher, use SQL Monitor to monitor the currently running SQL
Batches.
This is described in chapter 4 of the ASE System Administration Guide.

-bret

The Zero Impact Sql Monitor will accomplish your requirements plus much
more.  Refer to
www.sqlpower.com.

Quote:> Is there a tool to moniter all SQL commands on a Sybase database or at
least
> those from one user ?

>  I'm having problems with a 3rd party application and want to be able to
> filter out all commands sent from one user to see exactly  what's
happening.
> I can't get into the code or session to set traceon. Or is there a way of
> setting that centrally for another user ?

> We're using the Sybase interface driver not ODBC.

> Coming from a Microsoft SQLServer background I'm missing a tool like SQL
> Trace.

> Any suggestions are much appreciated.

> --
> Neville Higgs
> WAZ-Mediengruppe