The OER specifies the minimum memory requirements for a desired deployment size.
SQL Server allows you to customize the memory limit, to make sure the server will never consume all system memory.
To set the maximum amount of memory, see How to: Set a Fixed Amount of Memory (SQL Server Management Studio)
The following table outlines how much memory should be made available to SQL Server, for different deployments:
| Deployment | Required total RAM on the server | Memory Limit to Set for SQL Server |
|---|---|---|
| Up to 40,000 endpoints | 12 GB | 8 GB = 8192 MB |
| 40,001 to 70,000 endpoints | 32 GB | 27 GB = 27648 MB |
| 70,001 to 90,000 endpoints | 48 GB | 38 GB = 38912 MB |
| 90,001 to 110,000 endpoints | 64 GB | 86 GB = 88604 MB |
Note: Deployments smaller than 100 endpoints require SQLExpress only, which has a built-in maximum memory cap of 1 GB.
In order to restrict SQL memory usage, you can run following query from SQL management Studio (replacing the highlighted number with number of megabytes from the table above):
EXEC sys.sp_configure N'show advanced options', N'1' RECONFIGURE WITH OVERRIDE GO EXEC sys.sp_configure N'max server memory (MB)', 53248 GO RECONFIGURE WITH OVERRIDE GO EXEC sys.sp_configure N'show advanced options', N'0' RECONFIGURE WITH OVERRIDE GO
