I have a question regarding memory allocation to SQL Server 2016 Enterprise edition.
We are moving from 3 virtual machines (with Win Server 2008 R2 & SQL Server 2008 R2) to 2 virtual machines (Win Server 2012 & SQL Server 2016)
We are consolidating from 4 to 2 SQL Instances.
Current memory allocations (on SQL 2008):
Instance 1: 16GB
Instance 2: 20GB
Instance 3: 6GB
Instance 4: 6GB
These are quite busy live servers with a number of databases (back-end to web sites) & a number of SSIS packages (scheduled as Agent jobs).
I had requested 40GB for each server (8GB for OS, 32GB for SQL 2016), however I have been told this is too much and cannot be
justified. Memory is often flat-lined at 90% (See attached).
Microsoft state following memory requirement for any SQL 2016 edition: "At least 4 GB and should be increased as database size increases to ensure optimal performance."
Also, I have recommended that we use Enterprise versus Standard as it will confer overall system performance benefits.
Please can you make some memory recommendations for SQL Server 2016 Enterprise. Basically I need your exert opinion to help make a case for more memory.