Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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

Possible Duplicate:
Microsoft SQL Server 2008 Memory

I've explicitly set the Maximum Memory value in SQL server 2008R2 to 13,000 MB, however when I check task manager I see it is using 14,071,448 KB (13,741 MB)

I'm concerned because the server crashed recently due to a low memory condition where SQL server had allocated almost all of the server memory.

I've checked and the number I have entered is correct (i.e not entered in KB by mistake).

share|improve this question

marked as duplicate by jcolebrand Sep 7 '12 at 20:27

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

For SQL Server 2008 R2, "max memory" is for buffer pool only (basically data cache) Other memory is used for other things.

This is changed in SQL Server 2012

share|improve this answer
Ah, well that explains it then. Thanks for taking the time to answer! – David Meagor Mar 14 '12 at 8:25
@DavidMeagor Accept gbn's answer if you are satisfied with his explanation. – DaniSQL Mar 14 '12 at 17:46
then how can I set to a particular limit? – tesla747 Jul 27 '15 at 10:19

Not the answer you're looking for? Browse other questions tagged or ask your own question.