Sign up ×
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

migrated from 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
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

2 Answers 2

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
This should be a comment. – Matteo Italia Jul 11 '11 at 22:22
Try it on your SQL Server, allocate full RAM to SQL Server. See what happens. – gbn Jul 11 '11 at 23:46

Your Answer


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