Adjusting Memory After An Upgrade

[CTekGirl]

We have a Windows 2000 Server/MSSQL 2000 machine that was recently upgrade to 3gb of memory. I made an adjustment in the memory properties for the server.

Configuration option 'max server memory (MB)' changed from 2147483647 to 2024. Run the RECONFIGURE statement to install.

I ran the statement RECONFIGURE - I also ran sp_configure. Should the sp_configure results reflect this adjusment? I also stopped and started the Server and the sp_config results appear the same. Is there an additional step to verify this adjustment?

 

[CTekGirl]

Just checking in again to see if anyone had any feedback on this one?

 

[markdmac]

You will want to modify your Boot.ini file with the /3GB switch.

Here is an example from the MS web site:

[Boot Loader]
Timeout=30
Default=multi(0)disk(0)rdisk(0)partition(2)\WINNT
[Operating Systems]
multi(0)disk(0)rdisk(0)partition(2)\WINNT="Microsoft Windows 2000 Advanced Server" /fastdetect /3GB


I hope you find this post helpful. Please let me know if it was.

Regards,

Mark

 

[CTekGirl]

thx

 

[Designware]

CTekGirl,

You made a statement that you "made an adjustment in the memory properties for the server." Where exactly do you make this change on the server when you upgrade memory?

Thanks.

Dale