hello I am new to sqlanywhere I am using the -c option to set the initial ammount of memory, i have set the option in syabase central. when I start the service and look in task manager I can see that the service has not claimed the ammount of memory I have set, have I understood the -c option does it not set the ammount of ram the service should claim at start ?
i have set -c 1500m
thank you for your response.
asked 23 Apr '14, 15:28
Use SELECT PROPERTY ( 'CurrentCacheSize' ) to determine how big the cache is, in kilobytes. The -c option specifies the initial value, and the actual value can change over time unless you also specify -ca 0 to turn off automatic cache sizing. You can also control the minimum and maximum cache sizes with -cl and -ch. The memory numbers in Task Manager are not very useful IMO.
If SQL Anywhere is sharing a computer with other applications than automatic cache sizing is a wonderful thing for varying workloads. However, if the computer is dedicated to an industrial-strength SQL Anywhere database then settings like -c 90p -ca 0 make sense (cache size fixed at 90% of physical memory).
The rule of thumb is "you can never have too much cache".