Upgrading RAM on SQL Server 2000

Tags:
Microsoft SQL Server 2000
Microsoft Windows Server 2003
RAM
We use Windows 2003 Server Enterprise Edition and SQL Server 2000 Enterprise Edition. We use the /3GB switch in the boot.ini in an attempt to use more memory, and we are considering upgrading to 8GB of total RAM on our server. Could this negatively impact us at all?

Answer Wiki

Thanks. We'll let you know when a new response is added.

Adding more RAM will pretty much never have a negative impact on a SQL Server. Make sure that you have the AWE enabled within SQL Server (which you probably already have if you have the /3GB switch).

+++++++++++++++++++++++++++++++++++++++++

The only negative impact will be the few minutes it takes you to shut down the server, open the case, install the RAM, reboot the server and resync everything. Otherwise the RAM should improve performance.

Hope this helps!

-Schmidtw

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: