|
|
Posted by Erland Sommarskog on 06/30/06 22:19
tlyczko (tlyczko@gmail.com) writes:
> 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??
SQL Server is designed to get as much memory it can get and with a
reason: the more data and execution plans SQL Server can hold in cache,
the better it will perform.
If other applications on the same box calls for more memory, SQL Server
will yield, but it may not yield fast enough, so if that is a concern
it may be an idea to constraint the amount of memory that SQL Server
can get.
Then again, this is mainly something would do on a developer machine,
where you don't want broswers, Visual Studio, Word or whatever to be
swapped out, because you run a query from hell. Constrainting the amount
of memory box, is like driving your BMW on the third gear only.
If you are running IIS on the same box, you should either move IIS
to another box (I have no idea how much memory IIS needs, but it's
probably more than 100 MB than less) or get more memory. SQL Server
2000 Standard Edition can only use 2 GB of memory, so if you add 4GB
and turn on the /3GB switch, there will be some breathing room for
IIS.
I should add that the database size matters a bit. If your database
is small, say 1GB, it will fit entirely in cache, and you may need
all 2GB for memory.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
[Back to original message]
|