Michael Peppler <mpeppler@peppler.org> wrote in message news:<pan.2004.04.15.14.31.35.533253@peppler.org>. ..
> On Thu, 15 Apr 2004 05:39:15 -0700, Kaviall wrote:
>
> > 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?
>
> Look at the monitor server and historical server.
>
> Michael


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