March 21, 2012 at 1:26 pm
I have a SQL cluster with 32 GB of ram. It has 5 databases that equal 110 GB of RAM. The server is using a large amount of swap space. For this scenario what is the amount of ram I should put on the server?
March 21, 2012 at 4:37 pm
It is hard to say with this level of detail.
By swap space, do you mean paging file? And by "large amount", what does that mean in terms of GB?
If the 5 databases total 110GB in terms of the size of their data files, that tells us nothing about how much of that data is actually used. I could have a 500GB database where only 1GB is ever accessed. Do you know what percentage of your data is accessed? And of that, when it is accessed, how fast does it need to be? i.e. is it OK if SQL Server has to go to disk for the little-used data? If the answer is all 110GB is accessed, and every data access operation needs to be fast, then you need at least 110GB of RAM for your buffer pool plus some extra for expected growth.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply