I am having trouble with restricting SQL Server 2008's memory usage on our Windows Server 2008 server. The system has 11GB of RAM, I have tried restricting SQL's memory usage to 8.5GB by setting "Maximum server memory (in MB)" to 8500 but it is still currently using over 9.5GB of memory (even after a reboot).

Any ideas how to restrict it properly?

Thanks

link
feedback

merged by sysadmin1138 Apr 4 '11 at 21:11

this question was merged with SQL Server 2008 Max memory setting not taking affect because it is an exact duplicate of that question.