This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
My SQL Server 2019 memory allocation is set to Min memory of 0 (which I find normal) and Max memory of 2.14TB with 32gb RAM.
2.14 TB seems to be the default allocation, meaning nothing had been preserved for the OS. Should there be cause for alarm or should the max value be reduced by say 10%?
Thanks in Advance
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(12.8, 71%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERV%3C/text%3E%3C/svg%3E)
You should always leave some memory for the OS as you said. For a server running 32Gb of memory, I would set my MaxMem setting to around 24Gb (24,576 MB) assuming that Sql Server is the only application running on this server. This setting leaves around 8Gb for the OS which should suffice.
Hi @Robbie Varn Thanks for your input. Your answer is very close to a similar advice I have had. Will run on this
Glad to help
I would say leaving 8GB to the OS, with that small amount of RAM is bit too much. I would set max server memory to 28 GB, unless there are other things running on the machine as well.