SQL Server 2025 Memory Configuration on Small Windows Instances: max server memory and Lock Pages
Size SQL Server 2025 max server memory on 8-16 GB Windows instances, decide on Lock Pages in Memory, and configure tempdb and buffer pool without starving IIS or the OS.