Suggested Min/Max SQL Server memory

by Powellellogram   Last Updated January 12, 2018 13:06 PM

I've inherited multiple servers, each containing one database and one instance of SQL Server. Each server is set to use 12GB min/max memory and has Lock Pages in Memory enabled. The servers have a total of 16GB memory, so 4GB is left for the OS and anything else.

My question is - Is this best practice? Should the servers be set to the same value for min/max memory or will this cause performance issues? I'm investigating a sudden increase in CPU usage across multiple servers and want to rule this out if possible.



Related Questions


Can Entity Framework access In Memory OLTP Tables?

Updated September 26, 2018 22:06 PM

Disk space for schema only In-Memory-Tables

Updated August 15, 2017 14:06 PM

MSSQL - Query had to wait for memory grant

Updated December 06, 2017 13:06 PM


Mysql Tuning for a small server

Updated March 01, 2016 01:02 AM