Home > Archive > ASE Database forum > October 2005 > Is there a monitor tool?









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Is there a monitor tool?
Frank Rizzo

2005-10-27, 8:21 am

Occasionally I'd like to monitor the queries that come into ASE. Is
there a tool, similar to the SQL Profiles for MSSQL, that will let me do it?

Thanks
Mark K

2005-10-27, 8:22 am

I'm not familiar with SQL Profiles, but you can check out
dbcc traceon(11202)
to write the incoming SQL to the errorlog. It isn't necessarily pretty, but
it is good for occasional monitoring and debugging.

Mark Kusma
http://www.sybase.com/support/about...t/otherservices


"Frank Rizzo" <none@none.net> wrote in message
news:435c7d97$1@foru
ms-2-dub...
> Occasionally I'd like to monitor the queries that come into ASE. Is there
> a tool, similar to the SQL Profiles for MSSQL, that will let me do it?
>
> Thanks



Jeffrey R. Garbus

2005-10-27, 5:29 pm

Symantec (formerly Veritas) has a new tool in Beta for Sybase, which it has
been using on multiple other platforms for years. If you'd like to be added
to the list, email me privately.

Jeff Garbus

"Frank Rizzo" <none@none.net> wrote in message
news:435c7d97$1@foru
ms-2-dub...
> Occasionally I'd like to monitor the queries that come into ASE. Is
> there a tool, similar to the SQL Profiles for MSSQL, that will let me do

it?
>
> Thanks



Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com