SQL Clustered Instances automatic Max Server Memory settings
In our environment we have several SQL clusters, most of them in an active-active configuration. Microsoft recommends that the sum of all maximum server memory for all instances is equal to the total installed memory – memory reserved for the system. This means that during normal circumstances, more than half of the memory is not [...]
