• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 505
  • Last Modified:

max memory in sql server usage - setting

this sql server has 4GB ram in total.

in memory setting, the min mem is 0 and max is 2147483647

this is a dedicated sql server. is there any concern in the way it is defined above?
4 Solutions
Aneesh RetnakaranDatabase AdministratorCommented:
You can leave it as it or set the max value as 3.5GB.. Also please read this
Well SQL server will take memory as it needs it, so the more data that gets accessed the more data that will get put into RAM, so its good practice to set the max to about 1 - 2GB less then what the total system RAM is.  When the sql server service starts it will grab a small amount of RAM then as new data is accessed it will try and cache that data into RAM for an amount of time, if its not accessed again it will free that memory up, but it will NOT release it back to the system to use, it will just keep it reserved to cache more data.  This is because the perfomance is better to store data that it has already allocated in RAM then to request it from the system.

Usually on larger capacity (or RAM) sql servers I tend to try and reserve at least 4GB of RAM to the system.  Sqlsevr.exe process will not care about the system memory if you don't set a reserve and it will eventually try and take all the RAM in the system.
Of course if this server that you are setting up is not going to be a critical server, not hosting a lot of mission critical data (which I am assuming because of only 4GB of RAM), then you may not need to worry about it, but its good practice to limit the RAM.  If this is just a SQL Server Express installation then I wouldn't even really worry about it.
Anthony PerkinsCommented:
is there any concern in the way it is defined above?
Yes.  You need to install more memory.
Hi guys,

Please go throguh this link:


To change max memory setting in sql server usage please go through the below link:

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now