Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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 ?

share|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
add comment

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

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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.