Re: 300MB DB uses 1.4GB RAM!?

MEM TO LEAVE is 384 MB by default (-g is 256 MB default). Don't forget
about the other 128 MB set up to manage the possible default 255 worker
threads at 0.5 MB each. This is added to the -g parameter.

DBCC MEMORYSTATUS will tell you how SQL Server memory manager has
partitioned and allocated the BPool.


Anthony Thomas


--

"Kevin3NF" <kevin@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:eJxADxc%23GHA.4376@xxxxxxxxxxxxxxxxxxxxxxx
Yeah...but the default mem-to-leave is 256mb, right?

Data and index pages go into the Buffer pool.

So, if every page was in memory, there's 300mb. Mem-to-leave would have
to
have been set using -g to 900mb...

Odd.

--
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
http://kevin3nf.blogspot.com


"Edwin vMierlo" <EdwinvMierlo@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:%23%23gm%23gc%23GHA.2340@xxxxxxxxxxxxxxxxxxxxxxx
cache for :
queries / views / stored procedures / tables / indexes ... and a lot
more
which SQL holds in memory, when it has the RAM available



"Kevin3NF" <kevin@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:%23KaCkcc%23GHA.2300@xxxxxxxxxxxxxxxxxxxxxxx
300 MB database, not GB :)

The question is what is using the other 900MB?

My guess (in another thread on a another group - cross posted) is that
mem-to-leave is large and full.

--
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
http://kevin3nf.blogspot.com


"Edwin vMierlo" <EdwinvMierlo@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message
news:eq9A3%23Z%23GHA.4980@xxxxxxxxxxxxxxxxxxxxxxx
Unless you need to limit it (if you are running other processes on
the
same
machine), I wouldn't... the more ram SQL takes the better !!
really... you want SQL use all the availabe RAM and cache as much as
possible (in stead of going to disk)

IMHO


"Alex Persky" <alexvi@xxxxxxxxxxxxxx> wrote in message
news:%23V9pJrZ%23GHA.1220@xxxxxxxxxxxxxxxxxxxxxxx
It's going to grab as much as it can and will hardly give it back.

Yes, it's excessive. I would recommend set a limit on max amount of
memory
allocation for SQL Server. The default is unlimited (or a very high
number).
SQL Enterprise Management Console and right-click the server and go
to
properties.


"William Bernat" <nospamplease@xxxxxxxxxx> wrote in message
news:Ol4UcjG%23GHA.3348@xxxxxxxxxxxxxxxxxxxxxxx
SQL Server 2000 running nothing but a 300MB database over the
course
of
a
month of continuous use from a single application winds up
grabbing
1.4GB
of
RAM. Is that normal or excessive? (No performance degradation at
all,
jut
a
lot of RAM allocated.)



This is clustered, but the problem has occurred separately on each
node.
Yes, that took over 2 months to test.



-billb


















.

Relevant Pages

  • Re: Inter-process communication
    ... of available RAM. ... As far as "tuning" more generally goes, you'll note that part of the tuning that goes on is IIS ensuring that it doesn't starve other processes of memory. ... more memory even while physical RAM has 1GB or more available. ... The first part of any memory allocation involves allocating a chunk of virtual address space, whether or not there is sufficient physical RAM to satisfy that allocation. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Setting VM with WinXP-2K_Pagefile.vbs
    ... Also this is on my Backup XP where I have no RAM hogs ... >because of the unused portions of memory allocation requests. ...
    (microsoft.public.windowsxp.general)
  • Re: Dictionary Throws OutOfMemoryException
    ... | application has only allocated 1.3GB of RAM (according to the Task ... | memory is set to an initial 2GB with a maximum of 4GB of RAM. ... that you should initialize the dictionary to the size (in entries) you are ... and restrict the allocation of entries to what you effective need (well, ...
    (microsoft.public.dotnet.languages.csharp)
  • How to guarantee that an embedded (RealTime) application never causes a page fault
    ... What solutions exist for locking an application in RAM that uses dynamic memory ... quite a lot of dynamic memory allocation and deallocation takes ... heap that is first made resident in RAM. ...
    (comp.os.linux.development.system)
  • Re: how to determine if memory is slowing the server down
    ... Can it just be done without taking to much risks for the databases? ... limiting SQL Server's memory allocation. ... The largest memory hogs I've seen so far, ... SQL Server has a tendency to allocate a lot more memory for its ...
    (microsoft.public.windows.server.sbs)
Loading