We are experiencing performance issues on a 3 Node SQL Server 2008 Cluster. Active instance was on node 2 and the memory used by SQL Server was 31GB. Each node has 32gb of RAM. The SQL Server memory settings are 12gb minimum to 28 maximum. I question the memory settings for SQL Server and I suggest that it be modified to 10gb minimum to 20gb maximum. We had an issues with application having slow response time due to this memory issue. Also we discovered that SQL Server is using all 24 processors. Should we set SQL Server to use 14 processors instead?