SQL Server Min and Max in Virtualization

Scenario:   Guest VM Total Memory:  64GB SQL Server Max Memory:  58GB (Leaving 10%, or 6.4GB roughly for Windows + Apps) Guest VM Reservation:  48GB (75% of  Guest VM Total Memory;  in certain scenarios, 100% is preferred – if you can support it in failure situations) SQL Server Min Memory:  43GB which gives 5GB to Windows + Apps.  48GB * 10% = 5GB to Windows + Apps, 43GB to SQL Min Memory

Published At