Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Memory setting change in existing cluster Expand / Collapse
Author
Message
Posted Monday, April 29, 2013 7:03 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 6:18 AM
Points: 53, Visits: 220
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!



Post #1447491
Posted Monday, April 29, 2013 7:14 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 12:20 PM
Points: 41,529, Visits: 34,445
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 2008, MVP
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

Post #1447496
Posted Monday, April 29, 2013 7:31 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 6:18 AM
Points: 53, Visits: 220
Thank you.

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

Post #1447509
Posted Monday, April 29, 2013 7:35 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 12:20 PM
Points: 41,529, Visits: 34,445
AWE does, max server memory is immediate.


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
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

Post #1447515
Posted Monday, April 29, 2013 7:47 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 6:18 AM
Points: 53, Visits: 220
Thank you, again!
Post #1447528
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse