Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm planning an installation for SQL 2008 over Windows 2003. The server has 16g RAM. How much RAM I should assign to SQL server?

share|improve this question

migrated from stackoverflow.com Jul 12 '11 at 1:42

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

    
What other roles is the server going to be doing? – Dean North Jul 11 '11 at 22:08
    
32 bit or 64 bit? Dedicated SQL Server? – gbn Jul 11 '11 at 23:19
    
Belongs on ServerFault? – Seph Jul 11 '11 at 23:37
1  
This question belongs right here... it's a SQL Server Database configuration question. Just because the word server appears in the title does not mean it's a ServerFault question. – Michael Riley - AKA Gunny Jul 21 '11 at 19:48

12GB, leave 4GB for the OS.

This 12GB is for the various caches. The binaries and various out-of-process calls will use the 4GB, along with the OS.

share|improve this answer

This is an overly broad question... you'll need to describe your load/throughput/etc requirements.

My gut reaction is to say "all of it."

share|improve this answer
2  
This should be a comment. – Matteo Italia Jul 11 '11 at 22:22
2  
Try it on your SQL Server, allocate full RAM to SQL Server. See what happens. – gbn Jul 11 '11 at 23:46
    

Your Answer

 
discard

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