SQL Server Max memory for 64GB

25112
25112 used Ask the Experts™
on
right now the max memory option is default size (too big).

the actual physical size of RAM is 64GM.

this is a dedicated sql server. in this case, leaving it to default size is bad idea, as sql can start using up to 62,63,63.5GB and so forth? pl advise.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Principal Consultant
Commented:
SQL Server will take every bit of memory you give it and use it for buffer cache.  So setting max memory correctly is very important.  This is probably the #1 misconfigured item I see on SQL Servers.  Based on your description of your environment, I  would reserve 8GB or so for the OS and then monitor for OS memory issues.

Here is an excellent article on the details, including how to monitor memory.

http://www.sqlskills.com/blogs/jonathan/how-much-memory-does-my-sql-server-actually-need/

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial