Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

General RAM Recommendation for VMGuest OS Running SQL 2008 R2

Posted on 2012-03-21
6
Medium Priority
?
759 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 124

Accepted Solution

by:
Andrew Hancock (VMware vExpert / EE MVE^2) earned 336 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 332 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 332 total points
ID: 37750889
Microsoft recommendation is 4GB or more.
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 39

Assisted Solution

by:Aaron Tomosky
Aaron Tomosky earned 336 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 332 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 332 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] Lessons on Recovering from Petya

Skyport is working hard to help customers recover from recent attacks, like the Petya worm. This work has brought to light some important lessons. New malware attacks like this can take down your entire environment. Learn from others mistakes on how to prevent Petya like worms.

Question has a verified solution.

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

In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
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.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

609 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