HowTo: Audit query execution time?

[ola.th...@otsystem.com]

Dear readers

I would like to know if it’s possible to audit query execution time on
Sybase (ASE 12.5)? I’ve enabled auditing as described in “Installing
Auditing”:

http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.dc35823_1500/html/uconfig/uconfig156.htm

and I have enabled auditing of “cmdtext” and it seems to work just
fine. I’ll get a lot of records in the audit tables in sybsecurity-
database. There is one thing though and I would like to configure the
audit log to contain the execution time of each query. Is this
possible? If not, is there any other way to achieve similar logging?

The idea is to collect execution time for a period of time and then
examine the collected execution time data for average and peak query
times etc. and to identify which queries that take the longest time to
execute.

Regards, Ola

[SybaseNeal]

Hello,

I think you will find that the MDA tables are more suitable for this
type of monitoring:
http://www.sypron.nl/mda.html

They were made available starting in ASE 12.5.0.3 and have been
enhanced since then.

In particular I think you would find what you are looking for in the
"monSysStatement" table:
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.dc20022_1251/html/monitoring/monitoring60.htm

Thanks,
Neal