Upgrading RAM on SQL Server 2000

Tags:
RAM
SQL Server 2000
Windows Server 2003
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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following