Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

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.

asked 11 Jan '12, 14:34

wenbv's gravatar image

accept rate: 0%

edited 15 Mar '13, 18:33

Mark%20Culp's gravatar image

Mark Culp

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.

(11 Jan '12, 16:32) Mark Culp

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

(11 Jan '12, 17:14) wenbv
Replies hidden

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: - disks that are configured to not respect flush commands may lead to database corruption.

(12 Jan '12, 08:18) Mark Culp

This White Paper comes to mind:

"SQL Anywhere I/O Requirements for Windows and Linux"

permanent link

answered 12 Jan '12, 08:17

Dan%20Cummins's gravatar image

Dan Cummins
accept rate: 41%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 11 Jan '12, 14:34

question was seen: 3,444 times

last updated: 15 Mar '13, 18:33