Re: question about memory usage

From: John Oakes (john_at_nospam.networkproductions.net)
Date: 06/07/04 

Date: Mon, 7 Jun 2004 13:24:36 -0400

Do you have the Enterprise version of 2000?

-John Oakes

"Dan" <ddonahue@archermalmo.com> wrote in message
news:OX1gKzKTEHA.3016@tk2msftngp13.phx.gbl...
> Using SS2000. I'm having some timeouts on some queries from a web site and
> I'm trying to figure out why they're occurring. We have some dts packages
> that run every 30 minutes so there may be a conflict.
>
> We have memory configured dynamically for min - 0 and max 3583MB. However,
> when I look at System Monitor for SQL Server:Memory Manager:Total Server
> Manager, the memory is always around 1,678,880(KB). It only seems to
> fluctuate by a few MB. In looking at the Memory Object:% Committed Bytes
in
> Use for the system, it is always around 40%. Memory Object:Available
MBytes
> is about 1086. Between what SS is using and the system memory available,
> about 2.5G is accounted for. I don't know where the other 1G has gone to.
> I'm also wondering why SS never seems to get any more than 1.6G. Is it
> actually using all of the 1.6G or only a part of it? We have a 4 processor
> system and even when all 4 processors are around 80% processor time, the
> memory doesn't change.
>
> Any ideas or suggestions?
>
> Thanks,
>
> Dan
>
>
>

Relevant Pages

  • [PATCH] Update of Documentation/
    ... -memory subsystem of the Linux kernel. ... -swapcache reclaim. ... -Contains, as a percentage of total system memory, the number of pages at which ...
    (Linux-Kernel)
  • [PATCH v3] Update of Documentation/
    ... -memory subsystem of the Linux kernel. ... -swapcache reclaim. ... as a percentage of the dirtyable system memory (free pages + mapped ...
    (Linux-Kernel)
  • Virtual Memory Settings Locked
    ... I have a machine with 1GB RAM. ... The default system memory is 1.5 GB even ... though Task Manager shows that Page File usage rarely goes above 225 MB. ... I've run XP for weeks with virtual memory turned off completely with no ill ...
    (microsoft.public.windowsxp.general)
  • Re: What is the difference between /3GB and /PAE in boot.ini?
    ... System memory allocations are dynamic until they reach their maximum allocations. ... It allows the RAM above 4 GB to be addressed by changing memory addressing from 32-bit to 36-bit. ... The whole purpose is to fully utilize the memory available on the servers to increase the performance of the DB2 windows based servers. ...
    (microsoft.public.windows.server.general)
  • Re: Get Available System Memory
    ... but it could also be used to satisfy a memory request ... You seem to be intent on defining "currently available system memory" ... adjusting for buffer/cache, i.e. the so called "buffer adjusted" values? ... you've just finished running "fsck". ...
    (comp.unix.programmer)