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?
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
migrated from stackoverflow.com Jul 12 '11 at 1:42
This question came from our site for professional and enthusiast programmers.
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.
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."