SQL Server memory allocation

Question

SQL Server has 24 GB RAM and Minimum server memory is fixed at 0 MB RAM and max is 2147483647 MB. I would like to change max value to 19000 MB. Followed this document to determine the value. https://docs.centrify.com/Content/reports-topics/ADMemorySQLServerMaxSet.htm. Do I need to set the minimum value?

Answer 1

Hi SahaSaha-5270,

Agree with others.
And you can leave min server memory to default unless you have specific issues with min memory. Please refer to the similar thread which might be helpful.

Best Regards,
Amelia

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Hi,

(1) You do not have to set the minimum memory to more than zero in order to set the maximum, but you should usually keep the minimum memory in a system that includes more tasks.

(2) I would not recommend to learn from such post which include 2 sentences about something you can learn better from the official documentation (in fact, I am not sure if I would consider 2 sentences as a blog). I highly recommend to check this document:

https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/server-memory-server-configuration-options?view=sql-server-ver15&WT.mc_id=DP-MVP-5001699

For example you can Set only the max or only the min server memory options (not must to configure both)

sp_configure 'show advanced options', 1;  
GO  
RECONFIGURE;  
GO  
EXEC sys.sp_configure N'max server memory', 40960;  
GO  
EXEC sys.sp_configure N'min server memory (MB)', N'4096'  
GO  
RECONFIGURE;  
GO