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!