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.