Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

share
comments disabled on deleted / locked posts

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.

migrated from stackoverflow.com Sep 14 '09 at 12:04

This question came from our site for professional and enthusiast programmers.