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

Community
  • 1
David Meagor
  • 21
  • 2

1 Answers1

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

gbn
  • 70,237
  • 8
  • 167
  • 244