Solved

General RAM Recommendation for VMGuest OS Running SQL 2008 R2

Posted on 2012-03-21
6
757 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 121

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
Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

 
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

[Webinar] Learn How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT

Question has a verified solution.

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

A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
This video shows you how to use a vSphere client to connect to your ESX host as the root user. Demonstrates the basic connection of bypassing certification set up. Demonstrates how to access the traditional view to begin managing your virtual mac…

724 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