SQL Server Virtual Memory and Vmware

Posted on 2010-11-30
Last Modified: 2012-05-10

How can I justify 8g of SQL Server Virtual Memory on VMWare?



Question by:bibi92
  • 2

Accepted Solution

jcurrie earned 500 total points
ID: 34240092
The vmware Virtual Memmory is not a direct allocation. You are basically setting the upper limit that the specific guest OS can use from the shared pool of physical memmory. Because the VMware has it's own memmory manager that sits between the guest OS and the physical host, you can over-subscribe (over allocate) your memmory allocations. In my experience we have been able to over-subscribe substantially. If you are running a cluster of hosts with v-motion then it's even better because v-motion will just move your SQL server to a new host if the memmory utilization becomes to great for the current host in regards to the available memmory pool.

In essence, there is no reason not to give it 8GB of memmory if it performes better that way or if your SQL server sizing indicates that you should be using 8GB of RAM.

Author Comment

ID: 34240114
How to calculate the SQL Server size Virtual Memory?



Author Closing Comment

ID: 34240946
Thanks regards bibi

Featured Post

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Introduced in Microsoft SQL Server 2005, the Copy Database Wizard ( is useful in copying databases and associated objects between SQL instances; therefore, it is a good migration and upgrade tool…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

757 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