Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

moving sql to vmware vshere memory concerns Expand / Collapse
Author
Message
Posted Wednesday, January 8, 2014 3:47 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, November 7, 2014 4:56 AM
Points: 44, Visits: 144
I just created a Windows 2012 VM that will be running SQL Server 2012 I will also be creating a VM that needs to run SQL 2008. I have some concerns in regards to memory as of right now the 2012 vm has 8 gigs of ram. I would like to know how did everyone here guarantee that sql server got 8 gigs of ram did you go in an create a resource pool for your sql servers or did you edit the properties of the vm and manually configure the memory reservation? Anyway I'm curious in knowing how you are all handling memory in a virtual environment.
Post #1528824
Posted Friday, January 10, 2014 4:29 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, December 17, 2014 11:15 AM
Points: 257, Visits: 1,594
Are there going to be any other machines running on the host? How critical is this vm? The way to guarantee resources in VMWare is with reservations. You didn't mention any of the host resources, or the resources for the second vm.

You need to make sure the host has the minimum resources to function.

http://pubs.vmware.com/vsphere-4-esx-vcenter/index.jsp?topic=/com.vmware.vsphere.resourcemanagement.doc_40/managing_memory_resources/c_understanding_memory_overhead.html

Here are some recommendations from Brent Ozar on the guest.

http://www.brentozar.com/archive/2012/11/how-to-set-sql-server-max-memory-for-vmware/

When we build new virtual machines, we need to come up with three numbers:
• The guest’s memory – this is the amount of memory the guest thinks it has when it starts up. Let’s say we’re building a virtual machine with 32GB of memory.
• SQL Server’s max memory – I like to set this to leave 4GB of memory for the OS or 10%, whichever is greater. In this case, we’d set SQL’s max memory at 28GB, which would leave 4GB free for the OS.
• The VMware reservation – the lowest amount of memory the guest will have. Ideally, this is 100% of the guest’s memory, but that’s not always practical. If a host crashes, I’d rather be able to boot up all my guests with less memory than not be able to boot them up at all. For SQL Server, I generally set my reservations at 75% of the guest memory – in this case, 24GB.

Post #1530000
Posted Wednesday, September 17, 2014 11:17 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, September 17, 2014 11:07 PM
Points: 2, Visits: 1
Procedure
1


In the vSphere Client inventory, right-click the virtual machine and select Edit Settings.
2


Click the Hardware tab and select Memory.
3


Adjust the amount of memory allocated to the virtual machine.
4


Click OK to save your changes and close the dialog box.
Post #1614700
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse