Memory setting change in existing cluster

  • In my new job, I've inherited a SQL Server 2005 two-node cluster configured as active-passive.

    Each server is Windows Server 2003 R2 32-bit with 18 GB RAM.

    I thought that you need to make any changes to a cluster using Cluster Administrator. I'm not seeing anything in Cluster Administrator that refers to memory.

    In SSMS, I see that the memory settings are at their default. 'Use AWE' is not checked and the Max Memory is at 2147483647 MB. 2 petabytes??

    Do I use SSMS to change this? I suspect that I should change to check AWE and set Max Memory to 15300 MB, leaving 3 GB for the OS.

    Any suggestions or direction you can provide is appreciated. Thanks!

  • You change that through SQL, either with SSMS right click the server, properties, memory or using sp_configure

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • Thank you.

    Will the change require a restart of the SQL Server service?

  • AWE does, max server memory is immediate.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • Thank you, again!

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply