The forum will be down for scheduled maintenance on Saturday, March 4 beginning at 10am EST. Actual downtime is unknown but may be several hours.

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: 795 times

last updated: 02 Dec '13, 11:02