The forum will experience an outage sometime between February 10 at 7:00pm EST and February 12 at 11:59 EST for installation of security updates. The actual time and duration of the outage are unknown but attempts will be made to minimize the downtime. We apologize for any inconvenience.

Hi,

I have an application that performs quite some sql statements to a client sql anywhere database and sometimes it's hard to figure out what exactly is happening and would like to do some tracing on DB level.

I've tried a few methods to log/trace sql statements but only with moderate or no success.

I've tried the following things.

  1. Trace (Sybase central) , the newly created tracing-database seems to be empty ... or I just don't know where to look

  2. Application profiling. for some reason It shows a few sql statements but not the ones generated by my appliation, and even when I go to interactive sql and type a sql statement it does not appear in application profiling. What am I doing wrong?

  3. startup the server with "-zr sql" and save to a logfile. This has moderate success... I see sql statements and a whole lot more, sql statements look weird, with lots of parameters and hard to decode.

I would have like to use application profiling since it looks really nice, but it starts up and doesnt seem to update. I can see my connections though (in application profiling), and when I perform some sql statements in my application I see that the amount of memory used by that connection/application changes.

PS: Other things I've tried. Using "The monitor": gives nothing away of sql commands using third party profilers in my application, but unfortunately these fail as well.

some help would be appreciated.

asked 02 Dec '13, 07:07

soto's gravatar image

soto
96228
accept rate: 0%

What API are you using? For example, on Windows ODBC applications can be traced via the builtin ODBC tracing facility.

(02 Dec '13, 07:11) Volker Barth

It's a .net application that uses a dll: iAnywhere.Data.SQLAnywhere

So, it's no odbc I'm afraid.

(02 Dec '13, 07:16) soto

I do rarely use the tracing facility but Breck Carter has given a very detailed instruction list here:

Database Tracing In 50 Easy Steps

(02 Dec '13, 07:44) Volker Barth

I was looking in to that, thanks, but unfortunately, new queries just don't appear for some reason in the application profiling details...I can see my connections though (whenever I perform something in my application the Connection ID changes, so I know that Application profiling is aware of my app)... really weird, I'm probably missing something...

I've been carefull not to check 'only trace queries that take longer than 1 second'

(02 Dec '13, 09:44) soto

Use the two SQL commands to enable logging:

call sa_server_option  ('Request_level_log_file', 'c:\\temp\\sql.log');
call sa_server_option  ('Request_level_logging', 'SQL+hostvars')

you should find the sql commands in the created log file
Disable the logging again with:

call sa_server_option  ('Request_level_logging', 'NONE')
permanent link

answered 02 Dec '13, 11:02

Martin's gravatar image

Martin
8.6k114149237
accept rate: 14%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×11

question asked: 02 Dec '13, 07:07

question was seen: 773 times

last updated: 02 Dec '13, 11:02