|
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 |
|
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: |
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.