Andrew L. Smith-213145 (10/24/2013)What about the memory adjustments that each instance is supposed to do in the case of a fail-over to the same node? It is my understanding that each instance cooperates with each other and the OS to scale their memory usage to an acceptable level for each.

I want to be able to control my memory to give more to my ProdDBs and less to my ReptDBs if they are both on the same node.

Good idea - but you might want to adjust the max mem settings back to default if one of the two instances leaves the node. So if you add a schedule running hourly that resets the max memory to full capacity if the instances are running alone on the node, it will look almost perfect.

Henning Peter Jensen (10/26/2013)Good idea - but you might want to adjust the max mem settings back to default if one of the two instances leaves the node. So if you add a schedule running hourly that resets the max memory to full capacity if the instances are running alone on the node, it will look almost perfect.

As soon as an instance is failed-back, so that each instance is each running on a separate node, these scripts/jobs will reset the max mem to their defined high values - in my examples to 245GB.