Are there any considerations or things to set up in SQL Server 2005 when you upgrade the amount of RAM on the server that runs SQL Server? We are upgrading the server from 16 Gigs of RAM to 32. I know if SQL is restarted it should use the maximum amount of memory available in the settings, as we have it now. Thanks
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
RAM Upgrade
- Thread starter bob120579
- Start date
- Thread starter
- #3
OK ... since you are using 16GB already, I assume you are using the /PAE switch in the boot.ini and AWE is enabled.
Another check would be to see that you have allocated the new memory fix dynamically (in which SQL Server will take care of everything OR you have a fixed allocation that needs to be bumped out in order to add the additional 16GB.
A restart of the SQL services would then be in order.
Thanks
J. Kusch
Another check would be to see that you have allocated the new memory fix dynamically (in which SQL Server will take care of everything OR you have a fixed allocation that needs to be bumped out in order to add the additional 16GB.
A restart of the SQL services would then be in order.
Thanks
J. Kusch
- Status
Similar threads
- Locked
- Question