I am gonna build a new SharePoint 2016 farm,
- 2 web and app servers
- 2 DB servers cluster
What's the setting required for SQL memory in management studio?
In SQL Management Studio, there are two options for the Allocated
The Minimum Server memory in MB. (
Default value is 0).
The maximum Server memory in MB. (
Default value is 2147483647 about 2 TB)
Ex: if the installed RAM is 32 GB, so try to set it to
32- [(the allocated memory for OP) + other allocated memory for other systems]
Other systems like
For further details, check
An equation that may help you to calculate and set the Max Server memory limit.