SAP SQL Anywhere

Question

How can I log all commands the clients are sending to database server?

I wanna to "see" those commands to know how entity framework 4.0 is generating sqls and maybe try to change ling expressions.

Accepted Answer

I use these Commands to enable request level logging as needed.

-- Set Destination relative to db server !!!
call sa_server_option('Request_level_log_file', 'C:\temp\mylog.txt');

-- Log everything
call sa_server_option('Request_level_logging', 'ALL');
-- Log only SQL 
call sa_server_option('Request_level_logging', 'SQL');

For more Options see sa-server-option-system-sysproc

-- Add a Comment to the log file
call sa_audit_string('Ahead of Procedure call');

-- Stop logging
call sa_server_option('Request_level_logging', 'NONE');

With these commands you can switch on the logging from a iSQL Session before you press a Button in your Application. This make it possible to log only the interesting SQL code.

Answer 2

3

While request logging will log the statements, the Application Profiling feature within Sybase Central permits both the logging of all statements PLUS their graphical plans. As Application Profiling results are stored in a database, you can then mine the logging data using whatever specific criteria you desire (for example, listing only those statements that refer to a specific table, or only those statements that took longer than a certain elapsed time).

permanent link

answered 10 Mar '10, 17:06

Glenn Paulley
10.8k●5●76●106
accept rate: 43%

I never can to use this option. I can create perf db and start/stop capture, but I don't know how to analyse data. :(

(10 Mar '10, 20:20) Zote

2

@Glenn: I feel Zote's pain... there is a certain [cough] barrier to entry when it comes to getting the most out of Application Profiling... LogExpensiveQueries was easier even though it required a great deal of manual effort. It's a GUI thing, as in Graphic Usability Issues.

(10 Mar '10, 20:27) Breck Carter

@Glenn: Breck's comment says what I think too. A few SQL statements loaded from a script file, and off you go. I tried to use Application Profiling with a 9 GB database: creating the log database took hours. And finding the right way to get to analyzing the result was a real pain.

(11 Mar '10, 10:26) Reimer Pods

flat view

Answer 3

2	I guess "Request logging" will do what you request. I would try `dbsrv11 -zr SQL -zo RLL.log` (and possibly the other -zr options as well). permanent link answered 10 Mar '10, 16:18 Volker Barth 39.8k●358●546●815 accept rate: 34% flat view

Answer 4

0

You can switch on SQL logging capability locally in client side (see ODBC connection properties, advanced tab). In that case you don't need to have any administrative access to db server, and can intercept and analyse sql generated only by your application.

permanent link

answered 22 Jan '13, 06:45

AlexeyK77
707●6●12●24
accept rate: 8%

...as long as the client is using ODBC (whereas in Zote's original case, I guess it's a native ADO.Net connection and therefore not using ODBC at all)...

(22 Jan '13, 07:26) Volker Barth

flat view

SAP SQL Anywhere

SA11 Log all commands

Follow this question

Related questions