This White Paper comes to mind: http://www.sybase.com/detail?id=1092313 "SQL Anywhere I/O Requirements for Windows and Linux" answered 12 Jan '12, 08:17 Dan Cummins |
This White Paper comes to mind: http://www.sybase.com/detail?id=1092313 "SQL Anywhere I/O Requirements for Windows and Linux" answered 12 Jan '12, 08:17 Dan Cummins |
Once you sign in you will be able to subscribe for any updates here
By RSS:Markdown Basics
Question tags:
question asked: 11 Jan '12, 14:34
question was seen: 3,324 times
last updated: 15 Mar '13, 18:33
What type of "tuning parameters" are you looking for? OS tuning parameters or Database server tuning parameters or something else?
Note that the database server is designed to not require the developer/user to tune the server - yes there is always exceptions but out-of-the-box the server will adapt to the environment on which it is run.
so no need to worry about shmmax settings or other sort of environmental tweaks like one needs on other databases? how about setting caching parameters and things of that nature
SQL Anywhere uses file based shared memory on Unix platforms and therefore the setting of shmmax (and related values) is irrelevant.
You may want to read this whitepaper on SQL Anywhere I/O Requirements for Windows and Linux to make sure that your disk that holds your database is configured correctly: http://www.sybase.com/detail?id=1092313 - disks that are configured to not respect flush commands may lead to database corruption.