August 28, 2008 at 6:33 pm
I read somewhere that the general rule of thumb is that you should have the amount of RAM as big as your database file. Would anyone agree with that? If so why or why not.
If so if you had multiple db would you need the amount of RAM equal to the sum of the size of all database files.
August 28, 2008 at 10:27 pm
SQL Server is quite smart about how it uses memory. It is in no way constrained to the about of RAM being approximately the size of the database. There are many, many installations that have databases that are significantly larger than 100 gigabytes and it is quite common to find database larger than 10 gigabytes. All of these database work quite well if the database design is reasonable. I think you would agree that you are unlikely to find too many servers with > 4gigabytes and none with 100 gigabytes of RAM.
Having said that, it is really useful to have as much RAM as you can get since SQL will use it if it can.
August 29, 2008 at 2:52 am
i too have seen this before.
SQL server loves RAM, give it the amount you think it will need. if it requires more then add extra sticks
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply