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.

How do I get SQL Server (2005) to use all ram? (when upgrading ram after SQL Server installation, 16->32gb).

Total DB size are 50gb. ram usage grows and stops at 15.5gb.

Thanks.

share|improve this question
1  
the OS, as well as the DB edition: enterprise, etc is required to answer that. –  KM Jul 7 '10 at 13:01
add comment

migrated from stackoverflow.com Jul 7 '10 at 13:14

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

3 Answers

  1. Open SQL Management studio and connect to the instance
  2. Right-click the instance in Object Explorer and select 'Properties'
  3. Under 'Memory', see if someone has previously entered a static limit on the RAM usage ('Maximum Server memory in MB').

I'm guessing someone set a limit based on the previous ram and you'll want to either increase it or zero it out and let the server manage itself.

share|improve this answer
add comment

If you are using 64bit Windows and 64bit SQL Server, then you can configure SQL Server to use most of the RAM available - leave a couple of GB for the OS. Make sure that you enable Lock Pages In Memory, and that SQL Server is running on the latest service pack.

If you are using 32bit Windows and 32bit SQL Server, you'll need to enable AWE in SQL Server. You'll also need to consider whether to enable PAE depending on how much RAM you have.

From your comment about it stops around15.5GB, it sounds like you're running 32bit. Watch out - some of the Windows 2003 SP1 editions only allow up to 16GB.

share|improve this answer
add comment

Microsoft SQL Server 2005 - 9.00.4053.00 (X64) Standard Edition (64-bit)

Windows 2008 R2 Standard x64

share|improve this answer
    
Please edit the original question, or leave it as a comment; nobody will see this down here... Thank you and welcome to Server Fault! –  Chris S Jul 7 '10 at 14:34
add comment

Your Answer

 
discard

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