My OS is windows server 2008 R2 Enterprise, SQL Serer is 2008 R2 Standard edition, the installed is 128GB, and RAM identified by windows is 128GB, there are about 100 users using system at the same time every day, many functions of system are running slowly,
I set SQL Server maximum RAM 120GB, I observed more than 1 one month, the biggest RAM used by SQL Server (plus OS used) can't be over 74GB. could you please help why SQL Server can't use the RAM over 74GB? many thanks!
- This topic was modified 1 year, 10 months ago by 892717952.