OT: SQL Server Memory Consumption

  • Thread starter Thread starter rawCoder
  • Start date Start date
R

rawCoder

Hi,

How much SQL Server (sqlservr.exe) should be taking in memory ?

I know its a very generic question, but any link or reference related to the
memory conumption of SQL Server will be highly appreciated.

Thank You
rawCoder
 
Dude,

comp.databases.ms-sqlserver, or
microsoft.public.windows.server.general. Or try technet.
 
Sqlserver (with default setting) will take up as much as total RAM on the
system. It will release the resource back ONLY if the OS is requesting for
it. What it means is that the total memory used by Sqlserver does not go
down eventhough Sqlserver is now becoming idle. This is very much normal
(from sqlserver perspective) because you might need the resource again for
subsequent processing. It would cost too much to release the resource and
then reallocate for the next batch.

If you do not want to allow sqlserver to take up all the memory, you can set
the min/max limit. You can use SQL Enterprise Mgr or sp_configure to set
this.

Btw, if you have sql question, you would want to post to
microsoft.public.sqlserver.server or microsoft.public.sqlserver.programming.
These two are very well monitored.
 
You should be able to right-click on the server in Enterprise Explorer and
see what it is configured to use on the Memory tab. By default, it's going
to try to use all the physical memory you have. I like to set the maximum a
little lower.

sb
 
rawCoder said:
Hi,

How much SQL Server (sqlservr.exe) should be taking in memory ?

I know its a very generic question, but any link or reference related to the
memory conumption of SQL Server will be highly appreciated.

Thank You
rawCoder
Click to expand...
As the above respondents have said re mem consumption and appropriate
groups.
:)

SQL server will load each page into memory the first time it is accessed
and not unload it until it needs that memory for a
different page or the os has requested the memory back.

JB
 
Thanx all,

I didnt know of these sql newsgroups earlier.
Should have been more agile in this respect.

Thanx for you help
rawCoder
 
Back
Top