Wednesday, March 28, 2012

MS SQL Server Memory Supported

We are using SQL 2000 and being moved from old NT Servers having 2 G of RAM to new hardware with Win 2003 installed and 8GB of RAM.
Now can SQL 2000 use more than 2G of RAM on Win2003, if yes do we need to do any settings
Pls advise
Thanks
sanjay
Hello,
Only SQL server 2000 Enterprise Edition support more than 2 GB RAM. Other
editions will support only a
maximum of 2 GB.
If it is Enterprise edition then have a look into the below site to enable
more than 2 GB RAM to SQL server using AWE:-
http://www.sql-server-performance.com/awe_memory.asp
Thanks
Hari
MCDBA
"Sanjay" <Sanjay@.discussions.microsoft.com> wrote in message
news:DFD9B463-7A8F-48BA-BB9B-AB52BB35310F@.microsoft.com...
> We are using SQL 2000 and being moved from old NT Servers having 2 G of
RAM to new hardware with Win 2003 installed and 8GB of RAM.
> Now can SQL 2000 use more than 2G of RAM on Win2003, if yes do we need to
do any settings
> Pls advise
> Thanks
> sanjay

No comments:

Post a Comment