up vote 0 down vote favorite
share [g+] share [fb]

Following situation:

  • VMWare with Microsoft Server 2008 Enterprice edition 64-bit (4CPU and 32 GB RAM)
  • SQL server 2008 R2 64-bit enterprise.

In the taskmanager the SQLServer only takes up about 12 GB of ram. However, the min memory setting is 20GB (max - 30GB)

From what I understand, the VMWare always tries to take back memory from the SQL server. Does the Min Memory setting limit the amount of memory it takes back ?

Is there any other Cap on the max memory usage that i miss ?

link|improve this question
"SQLServer only takes up about 12 GB of ram." - that probably because when you checked that's all SQL Server has needed to use up to that point in time. – Mitch Wheat May 24 '11 at 5:55
I can still see a lot of memory pressure going on. So I believe that SQL server is still trying to get more memory. – Anonymous May 24 '11 at 6:36
"I can still see a lot of memory pressure going on" - what memory pressure? – Mitch Wheat May 24 '11 at 6:36
In perfrmon, the SQLServer:Memory Manager\Memory Grants Pending are constantly bigger than 0 In addition, the SQServer:Buffer Manager\Buffer Hit cache Ratio < 90% on a regular basis – Anonymous May 24 '11 at 9:07
I would monitor the SQLServer:MemoryManager:Total Server Memory counter. If there is memory pressure you should see it go down. – SqlACID May 24 '11 at 10:37
feedback

migrated from stackoverflow.com May 24 '11 at 10:08

This question came from our site for professional and enthusiast programmers.

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
or
required, but never shown
discard