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
sanjayHello,
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
> sanjaysql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment