Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

SQL AnyWhere 16 working with only one core after a few minutes/hours

Hi there,

I'm having an issue with Sybase SQL AnyWhere 16 with Windows Server 2012 Standard (x64) 8GB RAM, Xeon E3-1231, SSD Disc.

Since our application is running 64 bits, the DB is very fast at the beginning but after a few minutes or a few hours of usage (it dépends on Customer system...) the DB is becoming very slow.

What I can clearly see is that when it is slow the process "dbsrv16.exe" is only using one virtual core. If I restart the DB Service, it's workin fast for a few minutes again (working with all cores). And then again only with one core and very slow...

I tried to optimize with cache parameters. With 32 bits systems we only wrote "-c 45P" and it was ok, we never have had a performance issue.

With Cache parameters "-c 300m -ch 300m" it stays a little bit longer fast but it doesn't solve the problem.

If I put for example -c 1000m -ch 1000m it becomes slow after the first query (it works already with only one core).

I tried to use -gn -gnh parameters but nothing works fine.

Is it a bug of Sybase ? How can I fix that ?

The final result of this issue is that after a few time of usage, a query which takes normally 4-5 sec, needs 30 sec to be executed.

Thank you for your answer.

Not what you were looking for? View more on this topic or Ask a question