Please be aware that the SAP SQL Anywhere Forum will be shut down on August 29th, 2024 when all it's content will be migrated to the SAP Community.

Has anyone got experience of using Application Profiling in reasonably large scale live environments with v11.0.1?

The background:

We are trying to track down a potential rogue process which seems to be causing a database server to freeze up from time-to-time. The symptoms are that all users (approx 400) see their connections freeze up (in both our applications and Sybase Central etc - also new connections are refused) for 10-15 seconds before things return to normal (until the next time). While the freeze up is happening one CPU core goes to 100% and the other 17 go to zero (normally activity is well spread between cores). When the freeze up finishes most users carry on where they have left off - but some are disconnected.

We have not been able to associate the times of the freeze-up with any known user activity or timed event. So, sensibly enough, SAP Support have suggested using Application Profiling to try to identify the process that is causing the issue - as a first step to resolving it.

The problem:

However our experience in v10.0.1 was that while Application Profiling was fine to use in test (or very small scale production) environments - in busy live environments the servers were very quickly overwhelmed by the extra load placed on it (even when an external tracing database was used).

Unfortunately we cannot limit the Scope of the profiling since we have no idea where the problem is coming from. Also I'm not sure what would be appropriate settings for type and conditions when we are (at this stage) just trying to identify the problem process with minimum impact. I'm worried that just finding long running process won't help, since during the "freeze-up" all process will appear to be long running!

v11.0.1.2913 Win Server 2008 R2

asked 30 May '13, 11:32

Justin%20Willey's gravatar image

Justin Willey
accept rate: 20%

...and Foxhound didn't help at all?

(31 May '13, 09:38) Breck Carter

I have used it with an external tracing db for short times like 30 minutes or so, without seeing any noticeable degrading effect for the clients.

I have had a similar problem with 11.0.1 see: a sequential scan blocks all new connections

permanent link

answered 31 May '13, 03:30

Martin's gravatar image

accept rate: 14%


What was the resolution to that "sequential scan blocks" problem? wasn't clear from reading the thread.

(31 May '13, 09:41) Breck Carter
Replies hidden

no real solution, we managed to get around the situation which lead to the sequential scan

(31 May '13, 12:18) Martin

@Martin - thanks, that is encouraging - can you give a general idea of the scale of the system you were tracing - also the tracing level etc you used?

(01 Jun '13, 05:45) Justin Willey
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]( "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: 30 May '13, 11:32

question was seen: 2,065 times

last updated: 01 Jun '13, 05:45