Am I really using the full 2GB of Ram?

We have a machine Server2000 / SQL Standard 2000.
This machine has 2.5GB of RAM, but when we go into Task Manager we see
the SqlServr.exe process is only using 1,740,000 KB of memory.
This comes out to about 1.65 GB.
I have heard that this might actually be the max amount of memory that
will be consumed. In other words, have we really reached our max
memory allowed by SQL Server 2000 Standard?
Also, we are thinking about what we can do to allow us to take
advantage of over 2GB. Is it correct that we a) Must have SQL Server
Enterprise 2000 and b) must run on Windows 2000 Advanced Server or 2003
Datacenter edition?
THANKS!cmay,
SQL Server will only take as much RAM as it needs, and generally will
not release it unless asked for by the OS.
If you want to use more than 2Gb RAM for SQL Server you will need
Enterprise Edition.
Check out:
http://www.microsoft.com/sql/techinfo/planning/SQLResKChooseEd.asp
and
http://www.microsoft.com/sql/evaluation/overview/default.asp
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
cmay wrote:
> We have a machine Server2000 / SQL Standard 2000.
> This machine has 2.5GB of RAM, but when we go into Task Manager we see
> the SqlServr.exe process is only using 1,740,000 KB of memory.
> This comes out to about 1.65 GB.
> I have heard that this might actually be the max amount of memory that
> will be consumed. In other words, have we really reached our max
> memory allowed by SQL Server 2000 Standard?
> Also, we are thinking about what we can do to allow us to take
> advantage of over 2GB. Is it correct that we a) Must have SQL Server
> Enterprise 2000 and b) must run on Windows 2000 Advanced Server or 2003
> Datacenter edition?
>
> THANKS!
>|||Mark,
Thanks for the reply.
I basically have 2 follow up questions:
1) If a computer running 2000 Standard has maxed out its 2GB of
memory, will it actually show up as 2GB of memory under the
SQLServr.exe process in task manager? Some have suggested that our
1,740,000 KB (about) is really the max that SQL Server Standard will
consume, even though it only adds up to about 1.65GB of RAM.
2) Can Enterprise edition make use of over 2GB of Ram while running on
Windows 2000 Server, or must it run on W2k Advanced Server / Datacenter
edition? I have read lots of stuff that says you *can* install SQL
Enterprise on W2k Server, but I also read that in order to use over
2GB, it must use AWE, which is only available on Advanced Server /
Datacenter editions of windows.
Can you clarify this?|||"cmay" <cmay@.walshgroup.com> wrote in message
news:1118848547.194627.53370@.o13g2000cwo.googlegroups.com...
> We have a machine Server2000 / SQL Standard 2000.
> This machine has 2.5GB of RAM, but when we go into Task Manager we see
> the SqlServr.exe process is only using 1,740,000 KB of memory.
> This comes out to about 1.65 GB.
> I have heard that this might actually be the max amount of memory that
> will be consumed.
This is likely. Depending on your configuration.
> In other words, have we really reached our max
> memory allowed by SQL Server 2000 Standard?
Try pinning this memory if you want the process to take the full 2GBs.
USE master
EXEC sp_configure 'show advanced option', '1'
RECONFIGURE
EXEC sp_configure 'max server memory', '2048'
RECONFIGURE
EXEC sp_configure 'min server memory', '2048'
RECONFIGURE
EXEC sp_configure 'set working set size', '1'
RECONFIGURE
> Also, we are thinking about what we can do to allow us to take
> advantage of over 2GB. Is it correct that we a) Must have SQL Server
> Enterprise 2000 and b) must run on Windows 2000 Advanced Server or 2003
> Datacenter edition?
You will need SQL Server and Windows Server editions that are beyond the
"Standard" editions.
http://support.microsoft.com/default.aspx?scid=kb;en-us;274750
...|||Hi
SQL Server needs to leave about 256Mb or RAM in the MemToLeave area. This
allows for SQL Agent, XP's etc to run. With 2GB, the maximum SQL Server will
show is 1.65Gb.
Standard Windows 2000 supports up to 4GB or RAM. If you were to install SQL
server Enterprise Edition, it could use 3GB as the other 1GB is reserved for
the OS under Windows 32 bit.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"cmay" <cmay@.walshgroup.com> wrote in message
news:1118854442.903913.82200@.g47g2000cwa.googlegroups.com...
> Mark,
>
> Thanks for the reply.
> I basically have 2 follow up questions:
> 1) If a computer running 2000 Standard has maxed out its 2GB of
> memory, will it actually show up as 2GB of memory under the
> SQLServr.exe process in task manager? Some have suggested that our
> 1,740,000 KB (about) is really the max that SQL Server Standard will
> consume, even though it only adds up to about 1.65GB of RAM.
> 2) Can Enterprise edition make use of over 2GB of Ram while running on
> Windows 2000 Server, or must it run on W2k Advanced Server / Datacenter
> edition? I have read lots of stuff that says you *can* install SQL
> Enterprise on W2k Server, but I also read that in order to use over
> 2GB, it must use AWE, which is only available on Advanced Server /
> Datacenter editions of windows.
> Can you clarify this?
>|||Thanks Mike