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


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

In memory database error: table is full

Updated November 13, 2016 08:02 AM