Is it possible to log each SQL query statement received from clients for a Sybase ASE server 15.7 , same as SET general_log = 1;
command for mysql.
Thanks
Sybase ASE server request logs
logssybasesybase-ase
logssybasesybase-ase
Is it possible to log each SQL query statement received from clients for a Sybase ASE server 15.7 , same as SET general_log = 1;
command for mysql.
Thanks
Best Answer
you could enable the MDA tables (little performance overhead) then use first sp_monitor 'statement'. If it is not enough, you could select into the MDA tables to see the statement running in ASE server such as:
List of MDA tables: http://infocenter.sybase.com/help/topic/com.sybase.infocenter.dc70002.1550/pdf/asemtpst.pdf