Take the 2-minute tour ×
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.

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
    
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. –  Cape Cod Gunny Jul 21 '11 at 19:48
add comment

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

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

2 Answers

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

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

Your Answer

 
discard

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