We're having some sporadic performance issues in each application that accesses our database. I can't really tie it to load. We suspected a set of specific procedures, although we can run them via ISQL with no issues. I'm trying to do some Application Profiling and capturing in a tracing database. I've tried several options (on and off) but always get stopped at a certain point in creating the profiling database. Error: An error occurred while trying to create the tracing database. An error occurred while attempting to unload the database 'Billing2'. * SQL error: Syntax error near 'sajdbc'

Caused by: An error occurred while attempting to unload the database 'Billing2'.

Any suggestions? TIA.
Becky Snyder Bradley University

asked 20 Aug '19, 11:57

rsnyder's gravatar image

rsnyder
436121429
accept rate: 0%

2

Although it is specifically about v12, you may find this (un-official) step-by-step guide from Breck Carter helps: http://sqlanywhere.blogspot.com/2011/05/database-tracing-in-50-easy-steps.html

(20 Aug '19, 14:10) Justin Willey
Replies hidden
1

And do also consider the comments there, the same step seem to have failed for other folks...

(21 Aug '19, 03:36) Volker Barth
Be the first one to answer this question!
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:

×273
×32

question asked: 20 Aug '19, 11:57

question was seen: 712 times

last updated: 21 Aug '19, 03:36