locked
Clustered Environment Memory Configuration RRS feed

  • Question

  • We have two servers set up as a cluster.  Right now we have one isntance on one box and another instance on the other.  If one of the boxes were to fail, the instance would jump to the second server.

    Do we need to cap the memory when they are not running in fail over mode?  As in if there are 32gb of RAM in each server, I cap them each at 30 so we can use the hardware that we purchased.  But what happens when it fails over?  Together the SQL instances would be grabbing 60 gb which is of course more than what we have.

    Do they have a failover setting?
    --You bet I ate it--
    Wednesday, September 16, 2009 2:04 PM

Answers

  • No they don't.  You would have to create a custom startup stored procedure for each instance that checks SERVERPROPERTY('ComputerNamePhysicalNetBIOS') locally and over a linked server for the other instance.  If both return the same Node name then you would execute code to set max server memory on both instances to 14GB.  If the return different node names then you would execute code to set max server memory on both instances to 30GB. 
    Jonathan Kehayias
    http://sqlblog.com/blogs/jonathan_kehayias/
    http://www.twitter.com/SQLSarg
    http://www.sqlclr.net/
    Please click the Mark as Answer button if a post solves your problem!
    Thursday, September 17, 2009 1:39 PM