SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-08-2008, 03:25 PM
| ||||
| ||||
 Sybase Performance Metrics API 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      |
|
04-08-2008, 03:25 PM
| |||
| |||
| Re: Sybase Performance Metrics API 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 |
|
04-08-2008, 03:25 PM
| |||
| |||
| Re: Sybase Performance Metrics API 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 |
|
04-08-2008, 03:25 PM
| ||||
| ||||
| Re: Sybase Performance Metrics API On Thu, 15 Apr 2004 20:51:38 -0700, Kaviall wrote: > 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? 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@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 |
Linear Mode
