8GB RAM and SQL Server

• sqlstar2011

  SSCertifiable

  Points: 6000

  More actions

  June 5, 2006 at 7:36 am

  #60499

  I am increasing the RAM on my windows 2003 enterprise edition server from 4GB to 8GB. According to what I have read so far I am going to enable AWE and allow SQL Server to use 6GB and will leave 2GB for Windows.

  I am going to take following steps to accomplish this task

  1) add /PAE switch in boot.ini file

  2) run following commands in SQL Server Query Analyzer

  sp_configure 'show advanced options', 1

  RECONFIGURE

  GO

  sp_configure 'awe enabled', 1

  RECONFIGURE

  GO

  sp_configure 'max server memory', 6144

  RECONFIGURE

  GO

  Is there anything else that I should add to my list of steps? Also do I need to reboot the server or only restarting SQL Server service is good enough. FYI SQL Server is on a 4 node cluster.

  Thanks

• John Mitchell-245523

  SSC Guru

  Points: 148809

  More actions

  June 5, 2006 at 7:48 am

  #641671

  No need to cross-post.  Although this is the (more) appropriate forum, I've answered in the first place I found it, here:

  http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=92&messageid=284840