General RAM Recommendation for VMGuest OS Running SQL 2008 R2

Looking for just  rough / general recommendation on the amount of RAM that should be given to a VMGuestOS thats running SQL 2008 R2 on Windows 2008 R2.

Some considerations:

A maximum of 60 to 80 people would be connected to it at any given time.

The amount of data that will be inserted/updated per 24 hour period would not exceed 100 MB

Would 2 GB Suffice, or Should I consider 4 GB for this VMGuestOS ?

Any recommendations would be appreciated.
Who is Participating?
Andrew Hancock (VMware vExpert / EE MVE^2)Connect With a Mentor VMware and Virtualization ConsultantCommented:
I would recommend 2vCPU and a minimum of 8GB, using a RAID 10 datastore for storage of the virtual disks.
Svet PaperovConnect With a Mentor IT ManagerCommented:
4GB is the recommended minimum for Windows Server 2008. So, I will support @hanccocka's recommendations.
hirenvmajithiyaConnect With a Mentor Manager (System Administration)Commented:
Microsoft recommendation is 4GB or more.
A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

Aaron TomoskyConnect With a Mentor Technology ConsultantCommented:
I'll add that it really depends on what roles you plan on having. As just a fileshares you could indeed get by with 4gb. If you want to run dns/ad/radius/etc... Now you are definitely lookin at 8gb.
IanThConnect With a Mentor Commented:
I think 4gb is fine


it does depend also on the database imho
CarlosDominguezConnect With a Mentor Commented:
Although Microsoft recommends to leave 4GB only to the OS, I think 4 or 6 GB (total) must be OK.
In any case, soon you will see that the memory is being consumed by the sqlserver process. The combination W2008R2 + SQL2008R2 will get use of all the memory you have installed. It must not be a problem (if you are using the server only for SQL), so the recommendation is not to install any other service, role or third party software in that server.

If you need to install something else, or you experience problems with the server, you can limit the memory SQL Server could use:

If you do not limit the memory for SQL Server, it will take ll the available memory. It's just a question of time the graph in the task manager will show you almost near 90% used (nevertheless you install 4, 8 or 12 GB...)
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.