Sign up ×
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.

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.

1 Answer 1

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 at 10:19

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