We have a SQL Server 2K5 installation on a Windows 2003 R2 server with eight cores and 16GB of RAM. While it's in our plan to upgrade it to 64-bit, for now we are on the 32-bit version.
Currently we have one instance set to use all available memory, but need to run two instances. Given that this is 32-bit and this would be two separate SQL2K5 instances, would I have two instances contending for the first 4GB, or would they both be able to address 4GB+?
Thanks! -Bob