I have a 64bit server with 128Gb RAM installed and I am planning on putting a default instance of sql 2008r2 Standard Edition on it. I additionally intend to add a named instance as well on that server. I know that SQL 2008R2 SE is limited to 64Gb RAM but can the usage of 2 instances utilise all of the RAM available or will it have to share 64Gb?
Thanks in advance
Every day is a school day, and don't trust anyone who tells you any different.