2

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).

Improve this question
0

1 Answer 1

Reset to default
10

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

Improve this answer
2
  • Ah, well that explains it then. Thanks for taking the time to answer!
    – David Meagor
    Commented Mar 14, 2012 at 8:25
  • then how can I set to a particular limit?
    – tesla747
    Commented Jul 27, 2015 at 10:19

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