Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?



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 Sep 14 '09 at 12:04

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