MS SQL server: Single or multiple instances?
- by Hugo Riley
How costly (CPU or memory wise) is it to have multiple instances of SQL server 2005 instead of only one instance with prefixed databases?
A company have three application providers. They each will install one application and they each require two or three databases. Should they all use the same instance or should every provider use it's own named instance?
Is there any strong reason for one or other setup?