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

SQL Anyhwere v12.01 on Windows Server 2008R2.

We currently have about a 220GB database utilizing 56GB of RAM for a cache size. If we would add more RAM to our server (and allocate to database engine as cache), what type of performance improvement (if any) would we gain? Is there a point where adding more RAM will not get you any more benefits?

Thanks, Brian

asked 20 Jul '12, 13:51

bgreiman's gravatar image

accept rate: 20%

Is the engine currently using all the RAM that has been assigned to the cache?

If yes, then adding more may help.

If no, then adding more will not help.

(22 Jul '12, 07:11) Breck Carter

There can certainly be a point where adding more RAM is not going to net any noticeable benefit. There are many factors that can attribute to when you might see this. Such factors include concurrency, io/compute bound nature of the system, read/write distribution, etc.

Are you looking at overall performance and planning for this server? Or are you attempting to rectify an existing performance problem regarding specific statements/queries?

For capacity planning and performance evaluation, this whitepaper is a good start:

Capacity Planning with SQL Anywhere

permanent link

answered 20 Jul '12, 13:59

Tyson%20Lewis's gravatar image

Tyson Lewis
accept rate: 22%

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: 20 Jul '12, 13:51

question was seen: 2,553 times

last updated: 22 Jul '12, 07:11