Virtualization

SQL Server Min and Max in Virtualization

February 12, 2013 Rich 1 min read

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

Leave a comment