Hi,

I am pretty new to Sybase and Databases in general.
Working with Sybase ASE 11.9.2

I require to get various query statistics such as response times,
cache hits, lock statistics from my C code.

Could you guide me about how to go about doing this. I read about
sp_sysmon procedure. Is there any APIs that could be called instead?

Also, any pointers to the load on the Database itself when such
queries are fired regularly say every 1 minute?

Thanks in advance,
Kaviall

On Thu, 15 Apr 2004 05:39:15 -0700, Kaviall wrote:

Look at the monitor server and historical server.

Michael
--
Michael Peppler Data Migrations, Inc.
mpeppler (AT) peppler (DOT) org http://www.peppler.org/
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short or
long term contract positions - http://www.peppler.org/resume.html

Michael Peppler <mpeppler (AT) peppler (DOT) org> wrote


Thanks,

But we need to directly access the Sybase ASE statistics without the
Monitor server running. Does ASE provide any APIs to derefernce the
Shared mem statistics which the Monitor sefver would have done?

Thanks again,
Kaviall

On Thu, 15 Apr 2004 20:51:38 -0700, Kaviall wrote:

There's no published API that I know of. You might be able to get some
information from Sybase.

Michael
--
Michael Peppler Data Migrations, Inc.
mpeppler (AT) peppler (DOT) org http://www.peppler.org/
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short or
long term contract positions - http://www.peppler.org/resume.html