Solved

General RAM Recommendation for VMGuest OS Running SQL 2008 R2

Posted on 2012-03-21
6
751 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 118

Accepted Solution

by:
Andrew Hancock (VMware vExpert / EE MVE) 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
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

 
LVL 38

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

HOW TO: Connect to the VMware vSphere Hypervisor 6.5 (ESXi 6.5) using the vSphere (HTML5 Web) Host Client 6.5, and perform a simple configuration task of adding a new VMFS 6 datastore.
In this article, I will show you HOW TO: Create your first Windows Virtual Machine on a VMware vSphere Hypervisor 6.5 (ESXi 6.5) Host Server, the Windows OS we will install is Windows Server 2016.
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…
This Micro Tutorial steps you through the configuration steps to configure your ESXi host Management Network settings and test the management network, ensure the host is recognized by the DNS Server, configure a new password, and the troubleshooting…

914 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now