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/in...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