I'm trying to find an implementation guide for ASA 12 that can help us figure out what tuning parameters we need to be looking at and implementing. We're on Red Hat ES5 Any help would be greatly appreciated. |
This White Paper comes to mind: http://www.sybase.com/detail?id=1092313 "SQL Anywhere I/O Requirements for Windows and Linux" |
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.