?
Solved

SQL Server Max memory for 64GB

Posted on 2014-08-25
1
Medium Priority
?
208 Views
Last Modified: 2014-08-25
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.
0
Comment
Question by:25112
1 Comment
 
LVL 4

Accepted Solution

by:
Randy Knight, MCM earned 2000 total points
ID: 40283651
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/
1

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…

862 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question