Solved

General RAM Recommendation for VMGuest OS Running SQL 2008 R2

Posted on 2012-03-21
6
753 Views
Last Modified: 2012-03-27
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.
0
Comment
Question by:ACECORP
6 Comments
 
LVL 119

Accepted Solution

by:
Andrew Hancock (VMware vExpert / EE MVE^2) earned 84 total points
ID: 37750325
I would recommend 2vCPU and a minimum of 8GB, using a RAID 10 datastore for storage of the virtual disks.
0
 
LVL 20

Assisted Solution

by:Svet Paperov
Svet Paperov earned 83 total points
ID: 37750476
4GB is the recommended minimum for Windows Server 2008. So, I will support @hanccocka's recommendations.
0
 
LVL 7

Assisted Solution

by:hirenvmajithiya
hirenvmajithiya earned 83 total points
ID: 37750889
Microsoft recommendation is 4GB or more.
0
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 
LVL 39

Assisted Solution

by:Aaron Tomosky
Aaron Tomosky earned 84 total points
ID: 37750924
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.
0
 
LVL 30

Assisted Solution

by:IanTh
IanTh earned 83 total points
ID: 37751957
I think 4gb is fine

see
http://msdn.microsoft.com/en-us/library/ms143506.aspx

it does depend also on the database imho
0
 
LVL 5

Assisted Solution

by:CarlosDominguez
CarlosDominguez earned 83 total points
ID: 37752815
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: http://msdn.microsoft.com/en-us/library/ms191144.aspx

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...)
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

I have a large data set and a SSIS package. How can I load this file in multi threading?
Giving access to ESXi shell console is always an issue for IT departments to other Teams, or Projects. We need to find a way so that teams can use ESXTOP for their POCs, or tests without giving them the access to ESXi host shell console with a root …
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video shows you how easy it is to boot from ISO images for virtual machines with the ISO images stored on a local datastore on the ESXi host.

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question