Hello,

how can I find out which sql statements from database users are
currently processed and how long they already took? I want to find out
which queries slow down the database and increase the CPU usage.

Kind regards
Marten

See the documentation on sa_conn_activity:
http://dcx.sybase.com/index.php#http...y-sysproc.html

and also:

http://dcx.sybase.com/index.php#http...t-monitor.html

SQL Anywhere Developer Community:
http://www.sybase.com/developer/libr...ere-techcorner


SQL Anywhere Blog Center: http://www.sybase.com/sqlanyblogs




Marten Lehmann wrote:

Hello,

thanks.

Kind regards
Marten