Adding more RAM for MS SQL Server 2000

Hi

I have a MS SQL Server 2000 SP3 on MS Windows Server 2003 SP1 machine at my
hand. The SQL Server is configured for dynamic memory allocation. The machin
e
had 2GB of RAM in it when I installed the SQL Server. Now I've installed two
more gigabytes of RAM into the machine and I want to allow the SQL Server to
use a total of 3GB of RAM (by means of turning on the /3GB switch in Windows
boot.ini).

Do I also have to reconfigure any SQL Server parameters after enabling it to
use the additional gigabyte of RAM?

--
Many thanks,
Oskar

No.  All you have to do is add the /3GB switch to boot.ini and reboot.
If you wanted to address > 4GB of RAM then you would have to start
playing with AWE but <= 4GB is addressable with normal windows memory
addressing & therefore normal MSSQL dynamic memory management.

--
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@mallesons.nospam.com |* W* http://www.mallesons.com



Oskar wrote:

>Hi
>
>I have a MS SQL Server 2000 SP3 on MS Windows Server 2003 SP1 machine at my
>hand. The SQL Server is configured for dynamic memory allocation. The machi
ne
>had 2GB of RAM in it when I installed the SQL Server. Now I've installed tw
o
>more gigabytes of RAM into the machine and I want to allow the SQL Server t
o
>use a total of 3GB of RAM (by means of turning on the /3GB switch in Window
s
>boot.ini).
>
>Do I also have to reconfigure any SQL Server parameters after enabling it t
o
>use the additional gigabyte of RAM?
>
>--
>Many thanks,
>Oskar
>
>
>

Hi,

This will work out if your SQL server 2000 edition is Enterprise or Develope
r. Standard edition can support a maximum of 2 GB only.

Thanks
Hari
SQL Server MVP
"Mike Hodgson" <mike.hodgson@mallesons.nospam.com> wrote in message news:Ovp
sIwbZFHA.4088@TK2MSFTNGP15.phx.gbl...
No.  All you have to do is add the /3GB switch to boot.ini and reboot. If yo
u wanted to address > 4GB of RAM then you would have to start playing with A
WE but <= 4GB is addressable with normal windows memory addressing & therefo
re normal MSSQL dynamic memory management.

--
mike hodgson | database administrator | mallesons stephen jaques
T +61 (2) 9296 3668 | F +61 (2) 9296 3885 | M +61 (408) 675 907
E mailto:mike.hodgson@mallesons.nospam.com | W http://www.mallesons.com 



Oskar wrote: 
Hi

I have a MS SQL Server 2000 SP3 on MS Windows Server 2003 SP1 machine at my 
hand. The SQL Server is configured for dynamic memory allocation. The machin
e 
had 2GB of RAM in it when I installed the SQL Server. Now I've installed two
 
more gigabytes of RAM into the machine and I want to allow the SQL Server to
 
use a total of 3GB of RAM (by means of turning on the /3GB switch in Windows
 
boot.ini).

Do I also have to reconfigure any SQL Server parameters after enabling it to
 
use the additional gigabyte of RAM?

--
Many thanks,
Oskar