I have a Sybase Anywhere database, running multiple databases (in the same server/engine), a specific database (which has problems), has approximately 30 concurrent users. When the bank is started, everything becomes normal. After a random time of use, some queries become extremely slow. I wish I could verify, scientifically, what causes this slowness. Any error in the cache? Lack of memory? I need to identify the cause .. Currently, I stop the database (just the problematic database) and start it again. It works again. How can I do to identify the real cause of the problem? Thank you very much!

Forgiven, i have a very similar question... http://sqlanywhere-forum.sap.com/questions/15801/asa9-randomly-very-slow

asked 22 Mar, 09:31

DRauber's gravatar image

accept rate: 0%

closed 22 Mar, 10:24

You should check the properties UnschReq and ActiveReq in the Server-level properties (sa_eng_properties( ) or in PerfMon) to see if you have maxed out your worker threads. {hint: if you find the unscheduled request counter climbing then your -gn setting is likely too small}. Also watch how your cache resizing is working (may need to add the -cs switch).

You will also want to watch for blocking. {See sa_conn_info( ) and sa_locks(0,null,-1) on how to do that}

There is also procedure profiling and request logging available in 9.0.2. You might want to consider comparing a request logging sample from when the system is running efficiently to when it is heavily used. {You can turn that on/off with sa_server_option( ) or with Sybase Central}

Alternatively if you already have an idea that certain queries are running slow and later fast, then you could see (with dbisql's plan viewer) if the Plans are changing.

Unfortunately there is no one cause for slowness. It can be due to many different phenomena and tracking down which one is affecting you can be difficult.

permanent link

answered 22 Mar, 17:49

Nick%20Elson%20SAP%20SQL%20Anywhere's gravatar image

Nick Elson S...
accept rate: 31%

Thanks @nick! I will see this in the next time was occours!

(23 Mar, 07:42) DRauber
Your answer
toggle preview

Follow this question

By Email:

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



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:


question asked: 22 Mar, 09:31

question was seen: 90 times

last updated: 23 Mar, 07:44