If we have multiple instances of a SQL Server 2012 Standard Edition (which has a 64 GB memory limit) on one server which has 192 GBs of RAM, do both instances only have access to the first 64 GBs of memory, or can they access different portions of memory, so that they can each have their own 64 GB "chunk".
This is in consideration for an Active/Active cluster if both nodes fail over to a single node.
Knowing that two instances are absolutely not related to each other, i guess that you can use two instances on one server with 64gig for each. At least to my understanding, OS is the one who assigns memory to apps, so it should be fine :)
Some time ago, I had the same question. Sales reps from MS related company answered, that indeed, this is the case - you can use 64GB for each instance. They even went to say, that this is totally valid and part of the idea.
Unfortunately, I haven't yet a chance to test it.
I just wanted to follow up with a definitive answer on this. SQL Server Standard instances are not limited to the "first" 64GBs of memory. So, in the case above, on a server with 192 GBs of RAM, you can have 2 SQL Server instances both able to use a full 64GBs of memory.
Since neither of these instances are processor bound, we have taken the additional step of assigning each instance to it's own physical NUMA node through processor affinity. Thanks to Aaron Bertrand's comment as well as Bob Ward's excellent PASS 2012 presentation, "Inside the SQLOS 2012" for configuration details...