• Interesting article. I'm questioning the comment regarding "wasting memory" when the max memory setting is split between the two instances. Technically you would NOT want to split that memory evenly as you could choke the OS. Agreed that if the second instance is not running on the other node, then it be construed that the memory is being wasted, however; SQL will only pull the memory that it needs. It does not automatically assign that max memory to the server and reserve it. Actually if the OS needs some, SQL will release the memory back to the OS. I have seen an instance not start because there was insufficient memory but that is not that easily reproducible. The min memory setting does however have the ability to cause a problem as you are referring to.