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