memory usage/allocation/paging question
Are there any *negative* consequences to SQL Server 2000 Standard
paging to disk more often if one reduces the amount of available RAM
from 2.0 GB to 1.5 GB to give the OS and other apps enough RAM, other
than things possibly being "slower" and whatever wear and tear could
happen to the disk drives??
Or is it better to add in more RAM per se to bring the server up to 4
GB (Win2k3 Svr SP1)?? (it has a 4GB pagefile)
Is any information available about judging how much RAM the OS (Windows
2003 Server) should have available?? Does IIS require a lot of RAM??
Thank you, Tom
.
Relevant Pages
- Re: High memory usage (*HELP*)
... Low on virtual memory does not necessarily mean anything with regard to disk ... If your system uses all the available RAM, ... acceptable for a server to put all of its available RAM to use. ...
(microsoft.public.windows.server.sbs) - Re: Alocated Memory Error (SQLSERVR)
... but my understanding is that the MSDE instances are designed to ... and you don't want it grabbing all that RAM. ... running but non ever going about 200mb of memory usage. ... Server 2000 SP4, ...
(microsoft.public.windows.server.sbs) - Re: High memory usage (*HELP*)
... you can use Computer Management MMC to view the server logs. ... a server with 4 GB RAM, I doubt you need the second page file on D. So ... The virtual memory on D: drive is set to: 1550/3075 ... throttled ISA and Monitoring. ...
(microsoft.public.windows.server.sbs) - Re: XP Swapfile behavior
... > better performance because their is no constantly writing to the disk. ... >> paging large amounts to the swapfile (which is set 512 Mb min/max on ... >> mine) when the system has over 750Meg of free RAM? ... >> amount gets paged, and the drive is thrashing continually resizing it. ...
(microsoft.public.windowsxp.general) - Re: Server 2003 hangs... Event 2001, Event 2019!!
... with either a hard disk or RAM failure. ... Microsoft MVP: Windows Server ...
(microsoft.public.windows.server.general) |
|
