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

bgreiman
345151624
accept rate: 0%

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
2.2k1641
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

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "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:

×18

question asked: 20 Jul '12, 13:51

question was seen: 843 times

last updated: 22 Jul '12, 07:11