SQL Memory - Multiple instances same server

Question

Hello,

If I have 1 database server with 38 gb of memory and I have installed 2 SQL instances , how to do I split the memory between the 2 instances while leaving 20% memory for the OS ?

Thanks,
V

Answer 1

You will need to do this manually, as the two instances are not aware of each other. With 38GB available, you are looking at about 30GB available to split between the two. The easy thing is to assign a max memory of 15GB to each, but chances are they don't have equal workloads, so you will want to adjust accordingly. HTH