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
SQL Server Min and Max in Virtualization
Published by
