Named Instances and Performance
I am looking for any documentation that exists that evaluates the performance of instances of SQL Server running on the same hardware.
1. If you have two instances of SQL Server Standard, will they share the 2GB of ram that is the maximum for Standard, or will they each get 2GB?
2. what effect do the instances have on eachother. Is there any real benefit (or harm) to using 2 (or more) instances over a single really big instance?
THe situation is that the customer has SQL Server EE licences and they are truing-up with MSFT. They wish to make many of the licenses Standard... So they think by placing two instances of SQL Standard on a box they can, in essence, use 4GB of ram... two for each instance. I am looking to validate (or invalidate) that assumption without building all those test scripts. I can't be the first person to try and figure this out...
I am here to help you, not do it for you.
That is, unless you hire me. I am looking for work.