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
--
Michael Peppler Data Migrations, Inc.
mpeppler@peppler.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