SQL Server–Multiple Instances on same physical server
If you need instance separation – that is – you want to isolate two different databases completely – while hosting them on the same physical box, you can install SQL Server multiple times on the same box. This does incur additional licensing – however, you get the luxury of two different instances, completely isolated from each other – so the performance issues of one do not affect the other.
Leave a Reply