Take the 2-minute tour ×
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
add comment

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

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
2  
@DavidMeagor Accept gbn's answer if you are satisfied with his explanation. –  DaniSQL Mar 14 '12 at 17:46
add comment

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