SQL Server DBA

SQL Server configuration, memory, CPU, storage, and tempdb administration

Question

max server memory versus min server memory: how should each be configured?

Answer

Max caps memory-manager allocations (buffer pool, plan cache, grants), excluding thread stacks and external DLL allocations; leave headroom for those plus the OS. Min is a floor SQL Server won't release below once reached, not a startup allocation. Set max explicitly; usually leave min at default.

This is 14 of 25 free samples for SQL Server DBA.

More SQL Server DBA topic samples