Min and Max Memory in SQL Server 2016

It depends on memory architecture (e.g. NUMA) and the number and size of the databases. I would use 48GB as min and 240GB as max memory.

Do not go with the default settings.

Max Memory-
In this case we go with the rule 4GB or 10% (larger one), This means we are just leaving some memory for OS(Operating System).
Max Memory should be around 230GB. Also note that this is an online setting(meaning we can change it without restarting sql)

Min Memory-
Change it from 0 to 20.Also note that this is an online setting(meaning we can change it without restarting sql)
 
Note - These settings are for starting after that you can monitor and change accordingly.

Hi Pawan,

you mean in my scenario can i goahed with MIN 23 GB and MAX 230 GB?

What if i set both Min and Max memory to 240 GB?

These are heavy transactional databases? total around 35-40 DB's

What if i set both Min and Max memory to 240 GB?

Max memory is the important one. We should only focus on that.

What if i set both Min and Max memory to 240 GB?

That's ok as Min memory would not be immediately reserved. The Min memory configuration only says that after reaching the value set, do not release more memory than what's set.
Max memory of 240GB is really a good start since Windows OS shouldn't need more than the remaining 16GB.

Hi Virto,

When verified, in one of the SQL Server set to , Min=256 and Max=256. That total RAM in that server is 256.
Is it any issue?

Never set the max memory to the entire memory. This will lead to memory pressure for system tasks. You may start with 252GB and see whether you have OS issues, in this case lower that limit.

From a certain standpoint you may use 252/252 for min/max. This will give a little performance, cause SQL Server will not dynamically manage memory.

Good information.