Limit Memory Usage for Sybase SQL Anywhere

sybasesybase-sql-anywhere

I have to use Sybase's SQL Anywhere for a project so it has been put on a VM. Memory consumption is particularly high for a not overly taxed database and it's putting a lot of pressure on the VM.

The process is dbsrv12.exe and it's consuming >3GB of memory. Is there a way I can limit that to something more sensible and suitable for a VM?

Best Answer

Sybase's SQL Anywhere has startup parameters to control the min/max cache settings.

  -c  for the initial cache memory setting
  -ch for the maximum cache memory setting
  -ci for the minimum cache memory setting

If you set these appropriately it should constain the memory usage from the cache.

Here is a SQL Anywhere 12.0 page with those settings: http://dcx.sybase.com/1200/en/dbusage/limiting-using-perform.html

Related Question