Task manager shown sql server.exe with 22GB of memory???

Hi there is no reason for me to limit my memory, we do need more memory in this server to run, but I confuse why sqlserver.exe getting more memory, basically sqlserver.exe should and always consume little memory which just enough to boot the program and other memory will use by buffer pool which is internal to sql server

The TaskManager shows the memory consumed by:
1. The sqlservr.exe "code"
2. The "dynamic memory" allocated by SQL server to buffer the records and other data

So, the task manager does NOT JUST show the memory required to boot the program, but also the memory consumed while running (which is what you call buffer pool internal to sql server). Its the TOTAL memory consumed by the process which is quite large because the server might be fetching records and also buffering some of it for later use.

I found the article mentioned by Bahoopie very useful.  Note that MS say the sqlservr will continue to take memory on the off-chance that it may need it - but will release it if another process needs it.

I was able to set a maximum level using the method in the article - except that there is a problem in the syntx of the final command.  I used Bahoopies step-by step to input the command into osql.

motioneye - if your sqlservr is grabbing 22Gig - how much RAM does the server actually have?

Hi,
Our server has 32Gb of RAM which running with 64 bit edition of windows + sql, but what make me feel weird why in task manager it show me 22GB??? I have plenty of servers which running with big memory and only this server showing very huge memory used in task manager, others are only <1GB but internally sql consumed around the same amount too > 22GB